Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

how do you do this. please show formulas used Formatting as Table Styles F30 : * fx H A B D 67 Key Results: Appraisal

how do you do this. please show formulas used
image text in transcribed
Formatting as Table Styles F30 : * fx H A B D 67 Key Results: Appraisal of the Proposed Project 68 69 Net Present Value (at 10%) = $3,463.34 70 IRR = 21.09% 71 MIRR= 16.99% 72 Payback = 2.90 73 Discounted Payback = 0.00 74 Profitability Index 1.28 75 76 Data for Payback Years Years 2 77 4 0 -$12,400.00 1 $4,028.00 3 $4,192.59 78 Net cash flow $4,604.84 $7,680.54 79 Cumulative CF 80 Part of year required for payback 81 82 83 Data for Discounted Payback Years 84 Years 2 0 3 4 85 1 $4,028.00 Net cash flow -$12,400.00 $4,604.84 $4,192.59 $7,680.54 86 Discounted cash flow 87 Cumulative CF -$12,400.00 -$8,372.00 -$3,767.16 $425.43 $8,105.97 88 Part of year required for discounted payback 89 90 91 b. Now conduct a sensitivity analysis to determine the sensitivity of NPV to changes in the sales price, variable costs per unit, and Pasto 5 Marge & Center E Format 1 Filter Select

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Finance questions