Answer:
Lock-Tite Company
Cost of direct materials used = $160,000
Cost of direct labor used = $192,500 ($250,000 - $57,500)
Cost of goods manufactured = $446,975
Cost of goods sold = $462,375
* Gross profit = $1,237,625
Overapplied or underapplied overhead = $73,625
*Do not consider any underapplied or overapplied overhead.
Explanation:
a) Data and Calculations:
Inventories April 30 May 31
Raw materials $ 33,000 $ 32,000
Work in process 9,400 20,800
Finished goods 50,000 34,600
Activities and information for May:
Raw materials purchases (paid with cash) 171,000
Factory payroll (paid with cash) 250,000
Factory overhead:
Indirect materials 12,000
Indirect labor 57,500
Other overhead costs 110,000
Sales (received in cash) 1,700,000
Predetermined overhead rate based on direct labor cost 55 %
T-accounts:
Raw materials
Date Account Titles Debit Credit
April 30 Inventory balance $ 33,000
May Cash 171,000
May Factory overhead $12,000
May Work in process 160,000
May 31 Inventory balance $ 32,000
Work in process
Date Account Titles Debit Credit
April 30 Inventory balance $ 9,400
May Raw materials 160,000
Factory payroll 192,500
Factory overhead 105,875
Finished goods $446,975
May 31 Inventory balance $ 20,800
Finished goods
Date Account Titles Debit Credit
April 30 Inventory balance $ 50,000
May Work in process 446,975
May Cost of goods sold $462,375
May 31 Inventory balance $ 34,600
Factory overhead
Date Account Titles Debit Credit
May Raw materials 12,000
Payroll 57,500
Other expenses 110,000
May Work in process $105,875
May Underapplied overhead 73,625
Sales revenue = $1,700,000
Cost of goods sold (462,375)
Gross profit $1,237,625
A peach farmer must decide how many peaches to harvest for the world peach fair. He knows that there is a 25 percent chance that the world price will be $3, a 50 percent chance that it will be $3.50, and a 25 percent chance that it will be $4. His cost function is C(Q) = 0.05Q2. The farmer's maximum expected profit is:
a. $61.25.
b. 0.
c. $122.50.
d. None of the answers are correct.
Answer:
The correct option is a. $61.25.
Explanation:
Note: The correct cost function of the farmer is as follows:
C(Q) = 0.05Q^2 ……………….. (1)
Differentiating equation
MC = C’(Q) = 0.1Q
P = Expected price = (25% * $3) + (50% * $3.50) + (25% * $4) = $3.50 ……. (2)
Since profit is maximized when MC = P, we equate equations (1) and solve for Q which is the expected profit-maximizing quantity as follows:
0.1Q = 3.50
Q = 3.50 / 0.1 = 35
Substituting Q = 35 into equation (1), we have:
C(Q) = 0.05 * 35^2 = $61.25
R(Q) = Maximum expected revenue = P * Q = $3.50 * 350 = $122.50
The farmer's maximum expected profit = R(Q) - C(Q) = $122.50 - $61.25 = $61.25
Therefore, the correct option is a. $61.25.
The farmer's maximum expected profit is d. None of the answers are correct.
Data and Calculations:
The Probability that the world price will be $3 = 25%
The Probability that the world price will be $3.50 = 50%
The Probability that the world price will be $4 = 25%
Therefore, the expected world price = $3.50 ($3 x 25% + $3.50 x 50% = $4 x 25%)
Sales Revenue = S(Q) $3.50Q
Cost function = C(Q) = 0.05Q²
The farmer's Maximum Profit is given by the profit function, P(Q) = 3.50Q - 0.05Q²
Thus, the farmer's maximum expected profit is d. None of the answers are correct.
Learn more about the profit function with the sales revenue and cost functions here: https://brainly.com/question/8317828
Lap Corporation uses the weighted-average method in its process costing system. The beginning work in process inventory in a particular department consisted of 80,000 units, 100% complete with respect to materials and 25% complete with respect to conversion costs. The total dollar value of this inventory was $226,000. During the month, 150,000 units were transferred out of the department. The costs per equivalent unit for the month were $2.00 for materials and $3.50 for conversion costs. The cost of the units completed and transferred out of the department was:
Answer:
Lap Corporation
The cost of the units completed and transferred out of the department was:
= $825,000.
Explanation:
a) Data and Calculations:
Beginning work in process inventory = 80,000 units
Degree of completion = 100% materials and 25% conversion
Cost of beginning work in process = $226,000
Units transferred out = 150,000
Materials Conversion Total
Costs per equivalent unit $2 $3.50
Cost of units transferred out $300,000 $525,000 $825,000
= (150,000 * $2) (150,000 * $3.50)
Your team is working hard to develop a strategy to serve a new client. Which of the following actions is most important to ensuring an effective strategy is chosen?
a. Suggest that each proposed strategy be evaluated against a set of key objectives.
b. Invite the client into a meeting to shape the strategy.
c. Conduct a benchmarking survey of similar clients to determine best strategy.
d. Ask the team member with the most industry-related experience to lead the process.
Answer:
b. Invite the client into a meeting to shape the strategy.
Explanation:
It is very important when we invited the client for meeting so that we are able to share the strategy as the open and loose could be discussed in a proper way and in easy way also the suggestions are also welcome. In addition to this, the strategy should be taken place as per the preferences, requirements and choices of the clients
Therefore the option b is correct
Zisk Co. purchases raw materials on account Budgeted purchase amounts are April, $80,000, May, $110,000, and June, $120,000. Payments are made as follows: 70% in the month of purchase and 30% in the month after purchase. The March 31 balance of accounts payable is $22,000. Prepare a schedule of budgeted cash payments for April, May, and June. (I need ending accounts payable)
Answer:
A schedule of cash payments for April, May, and June is prepared.
Explanation:
The following image shows the calculation and explanation of the cash payment schedule.
Assume that instead of distributing a stock dividend, Sharper did a 3-for-1 stock split. Required: (1) Prepare the updated stockholders' equity section after the split. (2) Compute the number of shares outstanding after the split.
Complete Question:
On June 30, Sharper Corporation's stockholders' equity section of its balance sheet appears as follows before any stock dividend or split. Sharper declares and immediately distributes a 50% stock dividend. Common stock-$10 par value, 120,000 shares authorized, 72,000 shares issued and outstanding $ 720,000
Paid-in capital in excess of par value, common stock 310,000
Retained earnings 715,000
Total stockholders' equity $1,745,000
Assume that instead of distributing a stock dividend, Sharper did a 3-for-1 stock split. Required: (1) Prepare the updated stockholders' equity section after the split. (2) Compute the number of shares outstanding after the split. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Prepare the updated stockholders' equity section after the split.
Answer:
Sharper Corporation
1. SHARPER CORPORATION
Stockholders' Equity Section of the Balance Sheet June 30
Total stockholders' equity
Common stock-$3.33 par value, 360,000 shares authorized,
216,000 shares issued and outstanding $ 720,000
Paid-in capital in excess of par value, common stock 310,000
Retained earnings 715,000
Total stockholders' equity $1,745,000
2. The number of shares outstanding after the split is:
= 216,000 shares.
Explanation:
a) Data and Calculations:
Common stock-$10 par value, 120,000 shares authorized,
72,000 shares issued and outstanding $ 720,000
Paid-in capital in excess of par value, common stock 310,000
Retained earnings 715,000
Total stockholders' equity $1,745,000
Authorized shares = 360,000 (120,000 * 3)
Outstanding shares = 216,000 (72,000 * 3)
Common stock par value = $3.333 ($10/3)
b) A 3-for-1 stock split means that shareholders will now have 3 shares for each share that they previously held. Therefore, the outstanding and authorized shares will be multiplied by 3 while the stock price is divided by 3 to arrive at their values after the split.
Ayayai Corporation reported net cash provided by operating activities of $345,000, net cash used by investing activities of $145,000, and net cash provided by financing activities of $75,000. In addition, cash spent for capital assets during the period was $200,000. No dividends were paid. Calculate free cash flow.
Answer:
the free cash flow is $145,000
Explanation:
The computation of the free cash flow is given below:
The free cash flow is
= cash flow from operating activities - capital expenditures
= $345,000 - $200,000
= $145,000
hence, the free cash flow is $145,000
The same should be considered and relevant
Refer to the supply and demand data for a certain elective surgical procedure. Without health insurance, the equilibrium price and quantity would be: Group of answer choices $3,000 and 7,000. $2,000 and 11,000. $5,000 and 2,000. $4,000 and 4,000.
Answer:
$3,000 and 7,000
Explanation:
Please find attached the table used in answering this question
Equilibrium price is the price at which quantity demand equal quantity supplied.
Equilibrium quantity is the quantity that equates quantity demand with quantity supplied.
Above equilibrium price there is a surplus - quantity supplied exceeds quantity demanded. As a result of the surplus, price would fall until equilibrium is reached.
Below equilibrium price there is a shortage - quantity demanded exceeds quantity supplied. As a result of the shortage, price would rise until equilibrium is reached
The Assembly Department produced 1,000 units of product during March. Each unit required 1.25 standard direct labor hours. There were 1,300 actual hours used in the Assembly Department during March at an actual rate of $12 per hour. The standard direct labor rate is $12.5 per hour.
Required:
Assuming direct labor for a month is paid on the fifth day of the following month, journalize the direct labor in the Assembly Department on March 31.
Answer:
Debit Work in process for $15,625
Debit Direct labor time variance for $625
Credit Direct labor rate variance for $650
Credit Wage payable for $15,600
Explanation:
Before preparing the journal, the following calculations are done first:
Wage payable = Actual hours * Actual rate per hour = 1,300 * $12 = $15,600
Direct labor time variance = (Actual hours - Standard hours) * Standard direct labor rate = (1,300 - (1,000 * 1.25)) * $12.50 = $625 Unfavorable
Note: Direct labor time variance is Unfavorable because Actual hours is greater than Standard hours.
Direct labor rate variance = (Actual rate - Standard rate) * Actual hours = ($12 - $12.50) * 1,300 = -$650 Favorable
Note: Direct labor rate variance if Favorable because Actual rate is lower than the Standard rate.
Work in process = Wage payable + Absolute value of direct labor rate variance - Direct labor time variance = $15,600 + $650 - $625 = $15,625
The journal entries will now look as follows:
Date Particulars Debit ($) Credit ($)
Mar. 31 Work in process 15,625
Direct labor time variance 625
Direct labor rate variance 650
Wage payable 15,600
(To record the direct labor in the Assembly Department.)
Consider the market for orange juice. Suppose two events occurred last week. During the course of this past week, the price of oranges (used in the production of orange juice) decreased. At the same time, the price of coke (a substitute for orange juice) doubled. What are the likely effects of these TWO events on the equilibrium quantity Q* and price P* of orange juice
Answer:
these two events would lead to an increase in equilibrium quantity and have an indeterminate effect on equilibrium price
Explanation:
As a result of the decrease in the price of oranges which is use in the production of orange juice, there would be a rightward shift of the supply curve for orange juice. A a result, the supply of orange juice would increase and price of orange juice would fall
Substitute goods are goods that can be used in place of another good.
The doubling of the price of coke would lead to a decrease in the demand for coke and an increase in the demand for orange juice. This would shift the dead curve for orange juice to the right. As a result, both equilibrium price and quantity increases
these two events would lead to an increase in equilibrium quantity and have an indeterminate effect on equilibrium price
Selected current year company information follows:
Net income $15,953
Net Sales 712,855
Total liabilities, beginning-year 83,932
Total liabilities, end-of-year 103,201
Total stockholders' equity, beginning-year 198,935
Total stockholders' equity, end-of-year 121,851
Total asset turnover is:________.
a. 2.24 times
b. 2.81 times
c. 3.64 times
d. 4.67 times
e. 6.28 times
Answer:
b. 2.81 times
Explanation:
Calculation to determine Total stockholders' equity, end-of-year 121,851
Total asset turnover is:
First step is to calculate the Total assets
Beginning Ending
Total liabilities $83,932 $103,201
Total equity 198,935 121,851
Total assets $282,867 $225,052
Now let determine the Total asset turnover
Total asset turnover = $712,855/[($282,867 + $225,052)/2]
Total asset turnover= 2.81 Times
Therefore Total stockholders' equity, end-of-year 121,851
Total asset turnover is:2.81 Times
what are the basic requirement of ppe
Answer:
Personal safety equipment, commonly known as PPE, is the equipment used to minimize the risks causing severe injuries and diseases in the workplace.
Explanation:
Items like gloves, safety glasses, and shoes, earplugs or muffles, hard hats, breathing or coverings, jackets, and whole-body suits may be included in personal protective equipment.
All personal protective equipment should be designed and constructed in a safe and reliable manner. It should fit conveniently and promote the use of workers.
These wounds and diseases can be attributable to chemical, radiological, physical, electrical, mechanical, or other hazards in the workplace.
When engineering, employment practices, and administrative controls are not feasible or not sufficient, employers must provide their employees with personal protective equipment and ensure their proper utilization.
Alternative or non-traditional assessments are become more popular among teachers. One type of alternative assessment is called ___________
Answer:
Alternative or non-traditional assessments are becoming increasingly popular with teachers. An alternate evaluation type is called _Task
Explanation:
If a firm has a market beta of 0.9. is subject to an income tax rate of 35 percent, has a risk-free rate of 6 percent, a market risk premium of 7 percent, and has a market value of debt to market value of equity ratio of 60 percent, what does the market expect the firm to generate in terms of equity returns using CAPM?
a) 12.3%
b) 7%
c) 6%
d) 13%
Answer:
A
Explanation:
According to the capital asset price model: Expected rate of return = risk free + beta x (market rate of return - risk free rate of return)
risk free + (beta x market premium)
6 + (0.9 X 7) = 12.3%
state and explain five (5) challenges you will encounter as a service marketer.
Explanation:
1.Not finding your market segment
2.Not knowing how to explain the product or dervice you want to sell
Some of the challenges a service marketer faces are:
It being harder to sell a service than a product. The fact that services are perishable. Services being variable which means that others can offer it. Customers being rude. Finding it difficult to find a niche.A service marketer will find it harder to sell a service than a good because services are perishable which means that they cannot be stored like goods. People might therefore not want to buy because they can only use the service once.
Services are also variable which means that several people can offer it at reduced prices which makes it difficult to make a profit. Customers can also be rude.
Some services are also applicable to certain people and finding those people can be difficult to a service marketer.
Find out more on service marketing at https://brainly.com/question/6474788.
Use the following information to compute the cost of direct materials used for the current year. Assume the raw materials inventory account is used only for direct materials. (Assume no indirect materials.)
January 1 December 31
Inventories Raw materials inventory $6,700 $11,000
Work in process inventory 12,400 11,600
Finished goods inventory 10,900 7,500
Activity during current year Materials purchased $127,000
Direct labor 103,200
Factory overhead 47,700
Answer:
Direct material used= $122,700
Explanation:
Giving the following information:
January 1 December 31
Inventories Raw materials inventory $6,700 $11,000
Activity during current year Materials purchased $127,000
To calculate the direct material used, we need to use the following formula:
Direct material used= beginning inventory + purchases - ending inventory
Direct material used= 6,700 + 127,000 - 11,000
Direct material used= $122,700
A farmer purchased a module builder for $50,000. The bank is willing to loan him $37,000. The terminal value of this investment is $15,000. There is a marginal tax rate of 25%, a growth rate of 2%, and a discount rate of 10%. What is the after tax terminal value of this investment
Answer:
the after tax terminal value would be $14,500
Explanation:
Which of the following food borne illness has a preventative vaccine
A. E.coli
B.norovirus
C. Hep. A
D. Shigella
Answer:
C. Hep. A
Explanation:
From the available options, Hep. A is preventable with a vaccine. The vaccine was created in 1995. It is administered to individuals in two seperate doses and usually done with a time span of 6 months between dose. Having both doses administered helps prevent the individuals from the Hep. A virus long term. Like most vaccines, this one has a 95% effectiveness for preventing the virus from affecting the individual's body.
The unit quantity standard of a product is 3 pounds per package, and the unit quantity standard for machine hours is 0.40 hours per package. During August, 190,000 packages were produced. 430,000 pounds and 77,000 hours were used in production. How many pounds and how many machine hours should have been used for the actual output
Answer:
Standard pounds= 570,000 pounds
Standard hours= 76,000 hours
Explanation:
Giving the following information:
Standard pounds= 3 pounds per package
Standard hours= 0.40 hours per package.
During August, 190,000 packages were produced.
To calculate the standard quantity of pounds and hours that should have been used, we need to multiply the standard rate whit the actual output.
Standard pounds= 190,000*3= 570,000 pounds
Standard hours= 0.4*190,000= 76,000 hours
Beginning inventory for the month contained 3,000 units that were 35% complete with respect to materials. 57,000 units were completed and transferred out during the month. 5,500 units were in ending inventory, 10% complete with respect to materials. The weighted average equivalent units of production for materials for the month would be
Answer: 57,550 units
Explanation:
When using the weighted average method, the units completed and transferred out are assumed to include the opening inventory.
The weighted average equivalent units are therefore:
= Units completed and transferred out + Equivalent ending units
= 57,000 + (10% * 5,500)
= 57,000 + 550
= 57,550 units
All of the following are properties of typical indifference curves except Select one: a. indifference curves are bowed outward. b. higher indifference curves are preferred to lower ones. c. indifference curves do not cross. d. indifference curves are downward sloping.
Answer:
A
Explanation:
An indifference curve is a graph that shows the two combinations of goods for which an individual is indifferent in its consumption.
Points on an indifference curve represents various combination of goods to which an individual is indifferent to
higher indifference curve represents higher level of utility
Moccasin Company manufactures cotton shirts. 18,000 shirts are produced during the first week of July. The unit quantity standard is 3 meters cloth per shirt and the actual quantity used was 0.50 meters per shirt. Determine the quantity of cloth that should be used for the actual output of 18,000 shirts.
Answer: 54,000 meters
Explanation:
When determining the quantity of cloth t be used in the making of the shirts, it is best to use the standard quantity because this is what the company thinks that it needs to be able to produce a shirt.
Quantity of cloth for 18,000 shirts:
= Number of shirts * standard quantity per shirt
= 18,000 * 3
= 54,000 meters
Assume that management is evaluating the purchase of a new machine as follows: Cost of new machine: $800,000 Residual value: $0 Estimated total income from machine: $300,000 Expected useful life: 5 years The average rate of return on this asset would be _____. 15% 14% 13% 16% 2. Cash payback period is computed as _____. Initial Cost multiplied by Annual Net Cash Inflow Initial cost plus Residual Value divided by Net Cash Inflow Estimated Average Annual Income divided by Total Cash Inflow Initial Cost divided by Annual Net Cash Inflow
Answer: a. 15%
b. Initial Cost divided by Annual Net Cash Inflow
Explanation:
1. Cost of new machine = $800,000
Residual value = $0
Estimated total income from machine = $300,000
Expected useful life = 5 years
Average rate of return on this asset will be calculated thus:
Firstly, we'll calculate the net income per year = Total net income / Number of years = $300000/5 = $60000
Average investment = $80000/2 = $400000
Average rate of return = Net Income per year / Average investment = $60000/$400000 = 0.15 = 15%
2. Cash payback period is computed as the initial cost divided by the annual net cash inflow. It is the amount of time that is required for the cash inflows that is generated by a particular project to be able to offset its initial cash outflow.
of 20 >
Which of the statements concerning retirement accounts is true?
A.)Since Roth IRAs are funded with post-tax dollars, they are never as attractive as pre-tax traditional IRAs.
B.)Contributions to personal retirement accounts remain the property of the individual or heirs, but Social Security
payments are transferred to others.
C.)Individuals can allocate the funds in IRAs, 401(k)s, Roth IRAs, and Social Security accounts according to their risk preferences.
D.)Individuals do not pay income tax on Social Security contributions, but there are no tax benefits tied to personal
retirement accounts.
B. Contributions to personal retirement accounts remain the property of the individual of heirs, but SS payments are transferred to others.
Contributions to personal retirement accounts remain the property of the individual or heirs, but Social Security payments are transferred to others. Thus, option B is correct.
What is retirement?Retirement can be termed as when a person leaves an active work life and takes the decision of not returning to work. people usually tend to take retirement at the age of 50 to 60. they may take full, partial, or temporary retirement.
Retirement accounts are basically created by people to have a saving, a tax-free income, and that act as social security.
If you have a retirement account, then the amount that is in the account remains with the account holder itself, but the amount of social security gets transferred to the others. Therefore, option B is the correct option.
Learn more about retirement, here:
https://brainly.com/question/20751552
#SPJ2
Your firm has net income of $245 on total sales of $1,080. Costs are $610 and depreciation is $120. The tax rate is 30 percent. The firm does not have interest expenses. What is the operating cash flow
Answer:
the operating cash flow is $365
Explanation:
the computation of the operating cash flow is shown below:
operating cash flow is
= Net income + depreciation expense
= $245 + $120
= $365
hence, the operating cash flow is $365
We simply added the net income and the depreciation expense to determine the operating cash flow
Compute the following ratios: i. Current Ratio ii. Accounts receivable turnover iii. Average Collection period iv. Inventory Turnover v. Days in Inventory vi. Profit Margin vii. Debt to Total Assets viii. Return on Asset ix. Asset Turnover x. Payout Ratio
Answer:
i know only 3 ratio
i.current ratio=current assets
iv.inventory turnover=cost of goods sold
v.days in inventory=inventory turnover ratio /365 days
Which of the following statements about transportation costs are correct?
A. When transportation costs rise, markets tend to substitute goods that are from closer locations.
B. Transportation costs have declined due to technological improvements for transporting goods.
C. International transportation costs are increasing everywhere in the world except in the United States.
D. Since the 1960s, transportation costs, as a percentage of the value of all U.S. imports, increased twofold.
E. The decline in the U.S. relative cost of international transportation has contributed to a higher volume of trade.
Answer:
A. When transportation costs rise, markets tend to substitute goods that are from closer locations. B. Transportation costs have declined due to technological improvements for transporting goods. E. The decline in the U.S. relative cost of international transportation has contributed to a higher volume of trade.Explanation:
When transportation costs increase, people will try to save on these costs by buying goods from nearby locations instead as these would require less transport.
In general, transportation costs have declined as technological improvements in transport have improved with better rail lines and air shipping routes. In the U.S. this has led to an increase in trade volume because people are able to buy from markets far away from them knowing that they will not have to pay exorbitant prices.
A company purchased $2,300 of merchandise on July 5 with terms 2/10, n/30. On July 7, it returned $450 worth of merchandise. On July 12, it paid the full amount due. Assuming the company uses a perpetual inventory system, and records purchases using the gross method, the correct journal entry to record the payment on July 12 is:
Answer:
Dr Accounts payable 1850
Cr Merchandise inventory $37
Cr Cash $1813
Explanation:
Preparation of the journal entry to record the payment on July 12 Using the gross method,
JOURNAL ENTRY
Jul-12
Dr Accounts payable ($2300-450) 1850
Cr Merchandise inventory ($1850*2%) $37
Cr Cash $1813
($1850-$37)
(Being entry recorded for payment to supplier)
At the beginning of the year, Nothing More, Corp., had a long-term debt balance of $38,554. During the year, the company repaid a long-term loan in the amount of $11,714. The company paid $4,710 in interest during the year, and opened a new long-term loan for $10,250. What was the cash flow to creditors during the year
Answer: $6,174
Explanation:
Cash flow to creditors during the year is the amount that was paid to creditors less the amount that was received from them.
The relevant formula is:
= Long term loan repaid + Interest paid - Addition to long term loan
= 11,714 + 4,710 - 10,250
= $6,174
National Chemical Company manufactures a chemical compound that is sold for $52 per gallon. A new variant of the chemical has been discovered, and if the basic compound were processed into the new variant, the selling price would be $73 per gallon. National expects the market for the new compound variant to be 8,800 gallons initially and determines that processing costs to refine the basic compound into the new variant would be $132,000. Required: a. What would be the effect on total profit if National produces the new compound variant
Answer: $52,800
Explanation:
The effect on profit is:
= (Difference in selling price - Incremental cost per unit of producing the new variant) * Number of gallons of new gallons to be produced
= ((73 - 52) - (132,000 / 8,800) ) * 8,800
= ( 21 - 15) * 8,800
= $52,800
Profit is positive so they should produce the new variant.
What is the IRR for the following project if its initial after-tax cost is $5,000,000 and it is expected to provide an after-tax operating cash outflow of $(1,300,000) in year 1, followed by inflows of $2,900,000 in year 2, $2,700,000 in year 3, and $2,300,000 in year 4?
a) 15.57%.
b) 17.55%.
c) 13.57%.
d) 15.75%.
e) none of the above.
Answer:
e) none of the above.
Explanation:
The internal rate of return is the rate of return that equates the present value of cash outflows to the present value of inflows, in essence, a rate of return that gives a zero net present value.
The IRR can be determined using the excel IRR function as shown below:
=IRR(values)
the values are the cash flows arranged from the earliest in year 0 to the latest in year 4 as shown in the attached file.
