Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed 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 them

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

Business Mathematics

Authors: Gary Clendenen, Stanley A Salzman, Charles D Miller

12th Edition

0135109787, 9780135109786

More Books

Students also viewed these Finance questions

Question

8.16 Area East West South North

Answered: 1 week ago