Nadine Heru, the CEO of Heru Resources, hardly noticed the time as she was reviewing the engineering report just handed to her.

The report described a proposed new mine on the North Ridge of Mt. Diamond. A vein of zirconium ore had been discovered there on land owned by Ms. Heru?s company. Test borings indicated sufficient reserves to produce 340 tons per year of zirconium over a 7-year period. The vein probably also contained hydrated zircon gemstones. The amount and quality of these zircons were hard to predict, since they tended to occur in ?pockets.? The new mine might come across one, two, or dozens of pockets. The mining engineer guessed that 150 pounds per year might be found. The current price for high-quality hydrated zircon gemstones was$3,300 per pound.

Heru Resources was a family-owned business with total assets of $45 million, including cash reserves of $4 million. The outlay required for the new mine would be a major commitment. Fortunately, Heru Resources was conservatively financed, and Ms. Heru believed that the company could borrow up to $9 million at an interest rate of about 8 percent. The mine?s operating costs were projected at $900,000 per year, including $400,000 of fixed costs and $500,000 of variable costs. Ms. Heru thought these forecasts were accurate. The big question marks seemed to be the initial cost of the mine and the selling price of zirconium.

Opening the mine, and providing the necessary machinery and ore crunching facilities, was supposed to cost $10 million. There was a cheaper design for the mine, which would reduce its cost by $1.7 million. Unfortunately, this design would require much higher fixed operating costs. Fixed costs would increase to $850,000 per year at planned production levels. The current price of zirconium was $10,000 per ton, but there was no consensus about future prices. Some experts were projecting rapid price increases to as much as $14,000 per ton. On the other hand, there were pessimists saying that prices could be as low as $7,500 per ton. Ms. Heru did not have strong views either way: her best guess was that price would just increase with inflation at about 3.5 percent per year. (Mine operating costs would also increase with inflation.) Ms. Heru had wide experience in the mining business, and she knew that investors in similar projects usually wanted a forecasted nominal rate of return of at least 14 percent.

You have been asked to assist Ms. Heru in evaluating this project. Lay out the base-case NPV and IRR analysis and undertake sensitivity, or scenario analyses as appropriate. Assume that Heru Resources pays tax at a 35 percent rate. For simplicity, also assume that the investment in the mine could be depreciated for tax purposes straight-line over 7 years.

The Challenge

You have been hired as a consultant to advise Heru Resources on the opening of a new mine. The attached spreadsheet should be used to calculate the projections based on the details of the case. There are two sets of financials, side by side, so you can complete a comparison using different variable. You can manipulate the information in the green input cells to adjust projections to the income statement. You will need to create formulas to calculate the NPV and IRR calculations.

The sheet is not protected, so you can see the formulas. Use the spreadsheet and any other resources you would like to complete the following:

1. What is the NPV and IRR of the base scenario? (1

2. Which scenario is a better financial decision for the company; pay a higher opening cost and lower operating expenses, or pay a lower opening and higher operating costs??

3. Looking at the base scenario, at what discount rate is the project feasible? What information did you use to determine the rate?

4. Open the Best Case Scenario, and Worst Case Scenario tabs on this sheet. Complete the spreadsheet using information from the case to complete each. How does each scenario effect the decision to open the mine? What factor makes the biggest impact on the financial Analysis? )

5. Given your analysis, would you choose to open the mine? Why or why not??

Transcribed Image Text:

Heru Resources North Ridge Mine Financial Analysis Only adjust Green cells. Inputs Cost to open mine Ammount of Cash Invested Loan Amount Interest rate Annual Interest. Depreciation Discount Rate Operating Projections Annual Tons of Ore Price per ton of ore Pounds of Zircon Price per pound of Zirocn Inflation Rate tax rate Fixed Costs Variable Costs 8% 14% Option A Option B $ 10,000,000 $ 8,300,000 $ 7 $ 3.5% 35% $ $ $ $ ||$ $ 4,000,000 $ 6,000,000 $ 480,000 $ 1,428,571 $ 340 10,000 $ 150 3,300 $ 400,000 $ 500,000 $ Net Profit + Depreciation 4,000,000 4,300,000 "-can not exceed $9,000,000 344,000 1,185,714 Net Profit + Depreciation- 340 Option A 10,000 Operating Income 150 3,300 Income from Ore Income from Zircons Total Income 850,000 Operating Expenses 500,000 Fixed Costs Variable Costs Total Expense Income from Operations Interest Expense Depreciation Profit Before Taxes Taxes Net Profit Operating Expenses Fixed Costs Variable Costs Total Expense Income from Operations Interest Expense Depreciation Year 1 $ Profit Before Taxes Taxes Net Profit $ $ $ Cash Flow from Operations S Option B Operating Income Income from Ore Income from Zircons Total Income $ $ $ $ $ $ $ Year 1 $ $ $ $ $ S $ $ $ 5 $ Cash Flow from Operations $ 3,400,000 $ 495,000 3,895,000 $ 400,000 $ 500,000 $ 900,000 $ 2,995,000 $ 480,000 $ 1,428,571 $ 1,086,429 $ 380,250 $ 706,179 $ 2,134,750 $ 3,400,000 $ 495,000 $ 3,895,000 $ 850,000.00 $ 500,000.00 $ 1,350,000 $ 2.545,000 $ 344,000 $ 1,185,714 $ 1,015,286 S 355,350 $ 659,936 $ 1,845,650 S $ Option A Net Present Value Analysis Investment Cash Flow Yr 1 Cash Flow Yr 2 Cash Flow Yr 3 Cash Flow Yr 4 Cash Flow Yr 5 Cash Flow Yr 6 Cash Flow Yr 7 NPV IRR 2 3,519,000 $ 512,325 4,031,325 $ 414,000 $ 517,500 $ 931,500 $ 3,099,825 $ 480,000 $ 1,428,571 $ 1,191,254 $ 416,939 $ 774,315 S 2,202,886 $ 2 3,519,000 $ 512,325 $ 4,031,325 $ 879,750 $ 517,500 $ 1,397,250 $ 2,634,075 $ 344,000 $ 1,185,714 $ 1.104,361 $ 386,526 $ 717,834 $ 1,903,549 $ $ $ $ $ $ $ $ $ 3 3,642,165 $ 530,256 4,172,421 S 428,490 $ 535,613 $ 964,103 $ 3,208,319 $ 480,000 $ 1,428,571 $ 1,299,747 $ 454,912 $ 844,836 $ 2,273,407 $ 3 3,642,165 $ 530,256 $ 4,172,421 S 910,541 $ 535,613 $ 1,446,154 $ 2,726,268 $ 344,000 $ 1,185,714 $ 1,196,553 $ 418,794 $ 777,760 S 1,963,474 $ (10,000,000) 2,134,750 2,202,886 2.273.407 2,346,397 2,421,940 2,500,128 2,581,053 (580,232.77) 13.75% 3,769,641 $ 548,815 4,318,456 $ 443,487 S 554,359 $ 997,846 $ 3,320,610 $ 480,000 $ 1,428,571 $ 1,412,039 $ 494,214 $ 917,825 $ 2,346,397 $ 4 3,769,641 $ 548,815 $ 4,318,456 $ 942,410 $ 554,359 $ 1,496,769 : $ 2,821,687 $ 344,000 $ 1,185,714 5 1,291,973 $ 452,190 $ 839,782 $ 2,025,497 $ Option B Net Present Value Analysis Investment $ Cash Flow Yr 1 $ Cash Flow Yr 2 S Cash Flow Yr 3 $ Cash Flow Yr 4 $ Cash Flow Yr 5 $ Cash Flow Yr 6 $ Cash Flow Yr 7 $ NPV IRR 5 3,901,578 $ 568,024 4,469,602 $ 459,009 $ 573,762 S 1,032,771 $ 3,436,831 $ 5 3,901,578 $ 568,024 $ 4,469,602 $ 6 4,038,133 $ 587,905 4,626,038 $ 480,000 $ 480,000 $ 1,428,571 $ 1,428,571 S 1,528,260 $ 1,648,549 $ 534,891 $ 576,992 $ 993,369 $ 1,071,557 $ 2,421,940 $ 2,500,128 $ 975,395 $ 573,762 $ 1,549,156 $ 2,920,446 $ 475,075 $ 593,843 $ 1,068,918 $ 3,557,120 $ 6 4,038,133 $ 587,905 $ 4,626,038 $ 1,009,533 $ 593,843 $ 1,603,377 $ 3,022,662 $ 344,000 $ 344,000 $ 1,185,714 $ 1,185,714 $ 1,390,732 $ 1,492,947 $ 486,756 $ 522,532 $ 903,976 $ 970,416 $ 2,089,690 $ 2,156,130 S $ (8,300,000) 1,845,650 1,903,549 1,963,474 2,025,497 2,089,690 2,156,130 2,224,896 $265,030.38 15.00% 4,179,468 608,481 4,787,949 491,702 614,628 1,106,330 3,681,620 480,000 1,428,571 1,773,048 620,567 Project Life 1,152,481 $ 6,460,562 Net Profit 2,581,053$ 16,460,562 Cash Flow 7 4,179,468 608,481 4,787,949 1,044,867 614,628 1,659,495 3,128,455 344,000 1,185,714 1,598,741 559,559 Project Life 1,039,181 $ 5,908,885 Net Profit 2,224,896 $ 14,208,885 Cash Flow Questions to be answered: IRR 1. What is the NPV and IRR of the base scenario? (20 points) NPV ($80,232.77) $265,030.38 Option A (Full cost to open) Option B (Reduced cost to open) 2. (20 Points) Which scenario is a better financial decision for the company; pay a higher opening cost and lower operating expenses, or pay a lower opening and higher operating costs? 13.755 15.00 3. (20 Points) Looking at the base scenario, at what discount rate is the project feasible? What information did you use to determine the rate? 4. (40 Points) Open the Best Case Scenario, and Worst Case Scenario tabs on this sheet. Complete the spreadsheet using information from the case to complete each. How does each scenario effect the decision to open the mine? What factor makes the biggest impact on the financial Analysis? Heru Resources Best Case Scenario Only adjust Green cells. Inputs Cost to open mine Ammount of Cash Invested Loan Amount Interest rate Annual Interest Depreciation Discount Rate Operating Projections Annual Tons of Ore Price per ton of ore Pounds of Zircon Price per pound of Zirocn Inflation Rate tax rate Fixed Costs Variable Costs Option A $ $ 7 S Option B $ S $ - Net Profit + Depreciation▪▪▪▪▪ Net Profit + Depreciation "-can not exceed $9,000,000 Option A Operating Income Income from Ore Income from Zircons Total Income Operating Expenses Fixed Costs Variable Costs Total Expense Income from Operations Interest Expense Depreciation Profit Before Taxes Taxes Operating Expenses Fixed Costs Variable Costs Total Expense Income from Operations Year 1 $ Interest Expense Depreciation $ Ś $ $ S Ś $ $ Net Profit Cash Flow from Operation $ Option B Operating Income Income from Ore Income from Zircons Total Income $ $ Year 1 $ $ $ $ $ S Ś $ $ Profit Before Taxes Taxes $ Net Profit $ Cash Flow from Operation S - - - - - - $ - $ $ $ $ S $ $ $ $ $ $ $ $ $ $ $ $ $ - $ $ $ $ $ 2 2 Option A Net Present Value Analysis Investment Cash Flow Yr 1 Cash Flow Yr 2 Cash Flow Yr 3 Cash Flow Yr 4 Cash Flow Yr 5 Cash Flow Yr 6 Cash Flow Yr 7 NPV IRR $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ -S $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ - 4 $ $ $ $ $ $ $ $ $ $ $ Ś $ $ $ $ $ $ $ $ $ $ $ $ S T - - - . - . - - 5 Option B Net Present Value Analysis $ Investment Cash Flow Yr 1 $ Cash Flow Yr 2 $ Cash Flow Yr 3 S S Cash Flow Yr 4 Cash Flow Yr 5 $ Cash Flow Yr 6 $ Cash Flow Yr 7 S NPV IRR $ $ $ $ $ Ś $ $ $ $ $ $ $ $ = $ $ $ $ $ $ $ $ S $ $ - - - - - 6 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ - . - - - 7 Project Life $ $ Project Life $ $ Net Profit Cash Flow Net Profit Cash Flow Heru Resources Worst Case Scenario Only adjust Green cells. Inputs Cost to open mine Ammount of Cash Invested Loan Amount Interest rate Annual Interest Depreciation Discount Rate Operating Projections Annual Tons of Ore Price per ton of ore Pounds of Zircon Price per pound of Zirocn Inflation Rate tax rate Fixed Costs Variable Costs Option A $ $ Option B $ Net Profit + Depreciation Net Profit + Depreciation "-can not exceed $9,000,000 Option A Operating Income Income from Ore Income from Zircons Total Income Operating Expenses Fixed Costs Variable Costs Total Expense Income from Operations S Operating Income Income from Ore Income from Zircons Total Income Year 1 $ Operating Expenses Fixed Costs Variable Costs Total Expense Income from Operations $ Interest Expense Depreciation Profit Before Taxes Taxes Net Profit Cash Flow from Operation S Option B Interest Expense Depreciation Profit Before Taxes Taxes Net Profit $ $ $ $ $ $ $ $ Year 1 $ $ $ $ $ $ $ $ $ $ $ Cash Flow from Operation $ 10 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ or $ $ $ $ $ $ 2 2 Option A Net Present Value Analysis Investment Cash Flow Yr 1 Cash Flow Yr 2 Cash Flow Yr 3 Cash Flow Yr 4 Cash Flow Yr 5 Cash Flow Yr 6 Cash Flow Yr 7 NPV IRR $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 10 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 5 Option B Net Present Value Analysis Cash Flow Yr 2 Investment $ Cash Flow Yr 1 $ $ $ $ $ $ Cash Flow Yr 3 Cash Flow Yr 4 Cash Flow Yr 5 Cash Flow Yr 6 Cash Flow Yr 7 $ NPV IRR $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 7 7 Project Life $ Project Life $ $ Net Profit Cash Flow Net Profit Cash Flow Heru Resources North Ridge Mine Financial Analysis Only adjust Green cells. Inputs Cost to open mine Ammount of Cash Invested Loan Amount Interest rate Annual Interest. Depreciation Discount Rate Operating Projections Annual Tons of Ore Price per ton of ore Pounds of Zircon Price per pound of Zirocn Inflation Rate tax rate Fixed Costs Variable Costs 8% 14% Option A Option B $ 10,000,000 $ 8,300,000 $ 7 $ 3.5% 35% $ $ $ $ ||$ $ 4,000,000 $ 6,000,000 $ 480,000 $ 1,428,571 $ 340 10,000 $ 150 3,300 $ 400,000 $ 500,000 $ Net Profit + Depreciation 4,000,000 4,300,000 "-can not exceed $9,000,000 344,000 1,185,714 Net Profit + Depreciation- 340 Option A 10,000 Operating Income 150 3,300 Income from Ore Income from Zircons Total Income 850,000 Operating Expenses 500,000 Fixed Costs Variable Costs Total Expense Income from Operations Interest Expense Depreciation Profit Before Taxes Taxes Net Profit Operating Expenses Fixed Costs Variable Costs Total Expense Income from Operations Interest Expense Depreciation Year 1 $ Profit Before Taxes Taxes Net Profit $ $ $ Cash Flow from Operations S Option B Operating Income Income from Ore Income from Zircons Total Income $ $ $ $ $ $ $ Year 1 $ $ $ $ $ S $ $ $ 5 $ Cash Flow from Operations $ 3,400,000 $ 495,000 3,895,000 $ 400,000 $ 500,000 $ 900,000 $ 2,995,000 $ 480,000 $ 1,428,571 $ 1,086,429 $ 380,250 $ 706,179 $ 2,134,750 $ 3,400,000 $ 495,000 $ 3,895,000 $ 850,000.00 $ 500,000.00 $ 1,350,000 $ 2.545,000 $ 344,000 $ 1,185,714 $ 1,015,286 S 355,350 $ 659,936 $ 1,845,650 S $ Option A Net Present Value Analysis Investment Cash Flow Yr 1 Cash Flow Yr 2 Cash Flow Yr 3 Cash Flow Yr 4 Cash Flow Yr 5 Cash Flow Yr 6 Cash Flow Yr 7 NPV IRR 2 3,519,000 $ 512,325 4,031,325 $ 414,000 $ 517,500 $ 931,500 $ 3,099,825 $ 480,000 $ 1,428,571 $ 1,191,254 $ 416,939 $ 774,315 S 2,202,886 $ 2 3,519,000 $ 512,325 $ 4,031,325 $ 879,750 $ 517,500 $ 1,397,250 $ 2,634,075 $ 344,000 $ 1,185,714 $ 1.104,361 $ 386,526 $ 717,834 $ 1,903,549 $ $ $ $ $ $ $ $ $ 3 3,642,165 $ 530,256 4,172,421 S 428,490 $ 535,613 $ 964,103 $ 3,208,319 $ 480,000 $ 1,428,571 $ 1,299,747 $ 454,912 $ 844,836 $ 2,273,407 $ 3 3,642,165 $ 530,256 $ 4,172,421 S 910,541 $ 535,613 $ 1,446,154 $ 2,726,268 $ 344,000 $ 1,185,714 $ 1,196,553 $ 418,794 $ 777,760 S 1,963,474 $ (10,000,000) 2,134,750 2,202,886 2.273.407 2,346,397 2,421,940 2,500,128 2,581,053 (580,232.77) 13.75% 3,769,641 $ 548,815 4,318,456 $ 443,487 S 554,359 $ 997,846 $ 3,320,610 $ 480,000 $ 1,428,571 $ 1,412,039 $ 494,214 $ 917,825 $ 2,346,397 $ 4 3,769,641 $ 548,815 $ 4,318,456 $ 942,410 $ 554,359 $ 1,496,769 : $ 2,821,687 $ 344,000 $ 1,185,714 5 1,291,973 $ 452,190 $ 839,782 $ 2,025,497 $ Option B Net Present Value Analysis Investment $ Cash Flow Yr 1 $ Cash Flow Yr 2 S Cash Flow Yr 3 $ Cash Flow Yr 4 $ Cash Flow Yr 5 $ Cash Flow Yr 6 $ Cash Flow Yr 7 $ NPV IRR 5 3,901,578 $ 568,024 4,469,602 $ 459,009 $ 573,762 S 1,032,771 $ 3,436,831 $ 5 3,901,578 $ 568,024 $ 4,469,602 $ 6 4,038,133 $ 587,905 4,626,038 $ 480,000 $ 480,000 $ 1,428,571 $ 1,428,571 S 1,528,260 $ 1,648,549 $ 534,891 $ 576,992 $ 993,369 $ 1,071,557 $ 2,421,940 $ 2,500,128 $ 975,395 $ 573,762 $ 1,549,156 $ 2,920,446 $ 475,075 $ 593,843 $ 1,068,918 $ 3,557,120 $ 6 4,038,133 $ 587,905 $ 4,626,038 $ 1,009,533 $ 593,843 $ 1,603,377 $ 3,022,662 $ 344,000 $ 344,000 $ 1,185,714 $ 1,185,714 $ 1,390,732 $ 1,492,947 $ 486,756 $ 522,532 $ 903,976 $ 970,416 $ 2,089,690 $ 2,156,130 S $ (8,300,000) 1,845,650 1,903,549 1,963,474 2,025,497 2,089,690 2,156,130 2,224,896 $265,030.38 15.00% 4,179,468 608,481 4,787,949 491,702 614,628 1,106,330 3,681,620 480,000 1,428,571 1,773,048 620,567 Project Life 1,152,481 $ 6,460,562 Net Profit 2,581,053$ 16,460,562 Cash Flow 7 4,179,468 608,481 4,787,949 1,044,867 614,628 1,659,495 3,128,455 344,000 1,185,714 1,598,741 559,559 Project Life 1,039,181 $ 5,908,885 Net Profit 2,224,896 $ 14,208,885 Cash Flow Questions to be answered: IRR 1. What is the NPV and IRR of the base scenario? (20 points) NPV ($80,232.77) $265,030.38 Option A (Full cost to open) Option B (Reduced cost to open) 2. (20 Points) Which scenario is a better financial decision for the company; pay a higher opening cost and lower operating expenses, or pay a lower opening and higher operating costs? 13.755 15.00 3. (20 Points) Looking at the base scenario, at what discount rate is the project feasible? What information did you use to determine the rate? 4. (40 Points) Open the Best Case Scenario, and Worst Case Scenario tabs on this sheet. Complete the spreadsheet using information from the case to complete each. How does each scenario effect the decision to open the mine? What factor makes the biggest impact on the financial Analysis? Heru Resources Best Case Scenario Only adjust Green cells. Inputs Cost to open mine Ammount of Cash Invested Loan Amount Interest rate Annual Interest Depreciation Discount Rate Operating Projections Annual Tons of Ore Price per ton of ore Pounds of Zircon Price per pound of Zirocn Inflation Rate tax rate Fixed Costs Variable Costs Option A $ $ 7 S Option B $ S $ - Net Profit + Depreciation▪▪▪▪▪ Net Profit + Depreciation "-can not exceed $9,000,000 Option A Operating Income Income from Ore Income from Zircons Total Income Operating Expenses Fixed Costs Variable Costs Total Expense Income from Operations Interest Expense Depreciation Profit Before Taxes Taxes Operating Expenses Fixed Costs Variable Costs Total Expense Income from Operations Year 1 $ Interest Expense Depreciation $ Ś $ $ S Ś $ $ Net Profit Cash Flow from Operation $ Option B Operating Income Income from Ore Income from Zircons Total Income $ $ Year 1 $ $ $ $ $ S Ś $ $ Profit Before Taxes Taxes $ Net Profit $ Cash Flow from Operation S - - - - - - $ - $ $ $ $ S $ $ $ $ $ $ $ $ $ $ $ $ $ - $ $ $ $ $ 2 2 Option A Net Present Value Analysis Investment Cash Flow Yr 1 Cash Flow Yr 2 Cash Flow Yr 3 Cash Flow Yr 4 Cash Flow Yr 5 Cash Flow Yr 6 Cash Flow Yr 7 NPV IRR $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ -S $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ - 4 $ $ $ $ $ $ $ $ $ $ $ Ś $ $ $ $ $ $ $ $ $ $ $ $ S T - - - . - . - - 5 Option B Net Present Value Analysis $ Investment Cash Flow Yr 1 $ Cash Flow Yr 2 $ Cash Flow Yr 3 S S Cash Flow Yr 4 Cash Flow Yr 5 $ Cash Flow Yr 6 $ Cash Flow Yr 7 S NPV IRR $ $ $ $ $ Ś $ $ $ $ $ $ $ $ = $ $ $ $ $ $ $ $ S $ $ - - - - - 6 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ - . - - - 7 Project Life $ $ Project Life $ $ Net Profit Cash Flow Net Profit Cash Flow Heru Resources Worst Case Scenario Only adjust Green cells. Inputs Cost to open mine Ammount of Cash Invested Loan Amount Interest rate Annual Interest Depreciation Discount Rate Operating Projections Annual Tons of Ore Price per ton of ore Pounds of Zircon Price per pound of Zirocn Inflation Rate tax rate Fixed Costs Variable Costs Option A $ $ Option B $ Net Profit + Depreciation Net Profit + Depreciation "-can not exceed $9,000,000 Option A Operating Income Income from Ore Income from Zircons Total Income Operating Expenses Fixed Costs Variable Costs Total Expense Income from Operations S Operating Income Income from Ore Income from Zircons Total Income Year 1 $ Operating Expenses Fixed Costs Variable Costs Total Expense Income from Operations $ Interest Expense Depreciation Profit Before Taxes Taxes Net Profit Cash Flow from Operation S Option B Interest Expense Depreciation Profit Before Taxes Taxes Net Profit $ $ $ $ $ $ $ $ Year 1 $ $ $ $ $ $ $ $ $ $ $ Cash Flow from Operation $ 10 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ or $ $ $ $ $ $ 2 2 Option A Net Present Value Analysis Investment Cash Flow Yr 1 Cash Flow Yr 2 Cash Flow Yr 3 Cash Flow Yr 4 Cash Flow Yr 5 Cash Flow Yr 6 Cash Flow Yr 7 NPV IRR $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 10 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 5 Option B Net Present Value Analysis Cash Flow Yr 2 Investment $ Cash Flow Yr 1 $ $ $ $ $ $ Cash Flow Yr 3 Cash Flow Yr 4 Cash Flow Yr 5 Cash Flow Yr 6 Cash Flow Yr 7 $ NPV IRR $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 7 7 Project Life $ Project Life $ $ Net Profit Cash Flow Net Profit Cash Flow

Answer rating: 100% (QA)

Answer and explanations NET PRESENT VALUE Net Present Value NPV is the difference between the presen... View the full answer