Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I would like to find out the NPV, IRR Payback period . I have made the attached calculations. Please could you help check if it's

I would like to find out the NPV, IRR Payback period . I have made the attached calculations. Please could you help check if it's

image text in transcribedimage text in transcribedimage text in transcribed
Calculations of NPV for Option #2 Year 0 1 2 3 4 5 6 7 Purchase Price ($50,000) Maintenance (54,500) (54,500) ($4,500) (54,500) ($4,500) ($4,635) ($4,774.05) Materials ($25,000) ($20,000) ($20,000) ($20,000) ($20,000) ($20,000) ($20,000) Salvage ($10,000) Labor ($70,000) ($72,100) ($74,263) ($76,490.89) ($78, 785.62) ($81,149.19) ($83,583.66) Total Cost ($50,000) ($99,500) ($96,600) ($98, 763) ($100,990.89) ($103,285.62) ($105,784.19) ($118,357.71) Revenues $75.000 $100,000 $125.000 $155,000 $200,000 $150,000 Total Cash Flow ($50,000) ($99,500) ($21,600) $1,237 $24,009.11 $51,714.38 $94.215.81 $31.642.29 Return Rate 8% 1.0 0.9259 0.8573 0.7983 0.7350 0.6806 0.6302 0.5835 Present Value ($50,000) ($92,127.05) ($18,517.68) $987.49 $17,646.69 $35,196.80 $59,374.80 $18,463.28Calculations of ARR for Option #2 Total Revenue $805.500.00 Total Expenses ($723,281.41) Total Depreciation (540,000.00) Profit $42.218.59 Avg. Annual Profit $6031.23 ARR 12% Calculations of Cash Flow for Option #2 Year Cash Outflow Cash Inflow Uncovered Investment 0 ($50,000) ($50,000) (599,500) (5149,500) 2 ($21,600) ($171,100) $1.237 ($169.863) 4 $24,009.11 (5145.853.89) $51,714.38 (594.139.51) 6 $94.215.81 $76.30 7 $31.642.29 $31,718.59 Payback period is 6 yearso Net Present Value is = ($23,9T5?) It is the cash you received lions the project, less the present value of all cash outflows. o It is noted the Payback period is 6 years for Option No. 2 or the amount oftune it takes to recover the cost of an investment or reaches a break even point I ARR is 12 '34} {The rate of return formula is equal to current value minus original value divided by original value multiply by l. 'Where, Current Value = Current value of investment. Original Value = 1Value of investment ) I Avg. Annual Prot: Prot a\" Initial Investment = $31.23 :" $50,0 = 0.12 or 12%

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

Step: 3

blur-text-image

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

Financial Accounting Fundamentals

Authors: John Wild

4th Edition

0078025591, 9780078025594

More Books

Students also viewed these Accounting questions

Question

How to Construct a Stem and Leaf Plot

Answered: 1 week ago

Question

6. How can a message directly influence the interpreter?

Answered: 1 week ago