Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need to calculate payback period time and input the results in the excel file attached Payback Period Chart for Project Name Created by: Date:
I need to calculate payback period time and input the results in the excel file attached
Payback Period Chart for Project Name Created by: Date: Note: Enter the discounted costs and benefits for your project below. Add and delete rows as needed. Year 0 1 2 3 Costs Benefits Cum Costs Cum Benefits 140,000 0 140,000 0 37,200 186,000 177,200 186,000 34,400 172,000 211,600 358,000 31,600 158,000 243,200 516,000 600,000 500,000 400,000 Payback $ 300,000 200,000 100,000 0 0 1 2 Year cumulative costs cumulative benefits 3 2. (0.5 '34:) You want to estimate how many years it will take to payback the money you have spent earning ahachelor's degree. Hint Table and Figure similar to Figure 2-? on page 49. a. Assume your costs were $30,000 per year for four years {years 1, 2, 3, and 4) by paying for college and not working as many hours, and your benets were $10,000 per year for the next 30 years by getting a hetterjoh. Ignoring the time value of money, taxes, etc., in what year will you pay back for your college? (Hint: Find the year where the cumulative cash ow is equal to zero.) 11-. Be sure to type your response directly on the second cab of the worksheetwith your results and how you calculated themStep 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