Based on the information provided in the proforma statement attached below, comp
ID: 2740485 • Letter: B
Question
Based on the information provided in the proforma statement attached below, compute the Net Present Value, the Internal Rate of Return, the Cash Payback and the Accounting Rate of Return (CO 6). (Hint: Depreciation is not a cash item).
10%
Acme International Proforma Income Statements Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Sales revenue $ 580,000.00 $ 609,000.00 $ 639,400.00 $ 671,000.00 $ 745,500.00 $ 782,000.00 Less: Operating expenses $ 320,000.00 $ 336,000.00 $ 352,800.00 $ 370,400.00 $ 389,000.00 $ 408,500.00 Less: Depreciation expense $ 60,000.00 $ 60,000.00 $ 60,000.00 $ 60,000.00 $ 60,000.00 $ 60,000.00 Net income $ 200,000.00 $ 213,000.00 $ 226,600.00 $ 240,600.00 $ 296,500.00 $ 313,500.00 Initial cost of the investment: $ 600,000.00 Discount rate:10%
Explanation / Answer
1. Net Present Value using excel
2. Internal Rate of Return:
The IRR is the interest rate, also called the discount rate, that is required to bring the net present value (NPV) to zero.
3. Pay back
Payback period is 3 years because the cumulative cash flow at the end of 4th year becomes equal to initial amount of investment.
4. Accounting Rate of Return:
The calculation of accounting rate of return is calculated as:
Average net income is calculated by dividing the number of years the investment is expected to generate economic resources into the total net income for these same years.
Average net income = 248366.7
Accounting rate of return = 248366.7/600000 = 0.414
Year Cashflow Discount rate = 1/(1+0.1)^n Present Value 0 -600000 1 -600000 1 200000 0.90909091 181818.182 2 213000 0.82644628 176033.058 3 226600 0.7513148 170247.934 4 240600 0.68301346 164333.037 5 296500 0.62092132 184103.172 6 313500 0.56447393 176962.577 NPV 453497.96Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.