Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Solve for Project 1, 2 and 3 Discounted Payback. Use excel and show the steps taken to get the solution along with the formula, if
Solve for Project 1, 2 and 3 Discounted Payback. Use excel and show the steps taken to get the solution along with the formula, if any. Thank you.
Capital Budgeting Spreadsheet Example Module VIII Name: Date: Project 1 125,000 Project 200,000 Project 3 160,000 $ $ $ Initial Investment Cost of Capital Target Payback Period 8% 4 years 10% 4 years 12% 4 years Initial Investment Year Year Year Year Year Cash Flow Project 1 Cum. CF Discounted CF Cum. CF Project 2 Cum. CF Discounted CF Cum. CF Project 3 Cum. CF Discounted CF Cum. CF $ (125,000) $ (125,000) $ (125,000) $ (125,000) $ (200,000) $ (200,000) $ (200,000) $ (200,000) $ (160,000) $ (160,000) $ (160,000) $ (160,000) 1 $ 30,000 $ (95,000) $ 27,778 $ (97,222) $ 45,000 $ (155,000) $ 40,909 $ (159,091) $ 35,000 $ (125,000) $ 31,250 $ (128,750) 2 $ 30,000 $ (65,000) $ 25,720 $ (71,502) $ 45,000 $ (110,000) $ 37,190 $ (121,901) $ 40,000 $ (85,000) $ 31,888 $ (96,862) 3 $ 30,000 $ (35,000) $ 23,815 $ (47,687) $ 60,000 $ (50,000) $ 45,079 $ (76,822) $ 45,000 $ (40,000) $ 32,030 $ (64,832) 4 $ 30,000 $ (5,000) $ 22,051 $ (25,636) $ 60,000 $ 10,000 $ 40,981 $ (35,841) $ 50,000 $ 10,000 $ 31,776 $ (33,056) 5 $ 40,000 $ 35,000 $ 27,223 $ 1,587 $ 60,000 $ 70,000 $ 37,255 $ 1,414 $ 60,000 $ 70,000 $ 34,046 $ 989 multum Project 1 Project 2 Project 3 Which project(s) should be accepted? Payback Period Discounted Payback NPV IRRStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started