Question
what is the payback

u p fad Page Layout Formula One FINCH Cap Batting Gro Del me what you want to de Review View ACROBAT Quickbooks 3) Start up e
Currency Copy - X Payback 5 1. Understand how to use EXCEL Spreadsheet 6 (a) Develop proforma Income Statement Using Excel Sp
0 0
Add a comment Improve this question Transcribed image text
Answer #1

The payback period is the period by which we are able to recover the initial investment without taking into the account time value of money.

In the above question, our initial investment is $260,000. We recover $75,800 in the first year, $78,960 in the second year and $82,278 in the third year.

By the end of the third year, we are yet to recover = $260,000 - $75,800 - $78,960 - $82,278 = $22,962

In the fourth year, we recover $117,612, therefore we recovered the initial investment before the completion of the fourth year. We recovered the remaining portion of the initial investment ($22,962) during the fourth year. To calculate that we need to divide the remaining portion of the initial investment with the cash flow of the fourth year.

=22,962/117,612 = 0.20

So that means we recovered the full initial investment by .20 of the fourth year.

Total Payback period comes out to be 3.2 years

Add a comment
Know the answer?
Add Answer to:
what is the payback u p fad Page Layout Formula One FINCH Cap Batting Gro Del...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 1. undersatnd how to use EXCEL Spreadsheet (a) Develop proforma Income Statement Using Excel Spreadsheet (b)...

    1. undersatnd how to use EXCEL Spreadsheet (a) Develop proforma Income Statement Using Excel Spreadsheet (b) Compute Net Project Cashflows, NPV, and IRR (c) Develop problem-solving and critical thinking skills and make long-term investment decisions 1) Life Period of the Equipment = 4 years 2) New equipment cost $(200,000) 3) Equipment ship & install cost $(35,000) 4) Related start up cost $(5,000) 5) Inventory increase $25,000 6) Accounts Payable increase $5,000 7) Equip. salvage value before tax $15,000 8) Sales...

  • Q#2 Impact of 2017 Tax Cut Act on Net Income, Cash Flows and 8 Capital Budgeting...

    Q#2 Impact of 2017 Tax Cut Act on Net Income, Cash Flows and 8 Capital Budgeting (Investment) De cisions 59 (a) Estimate NPV, IRR and Payback Period of the project if equipment is fully 60 depreciated in first year and tax rate equals to 21 %. Would you 61 accept or reject the project? 62 (b) As a CFO of the firm, which of the above two scenario (a) or (b) 63 would you choose? Why? FINC 3310-Fall 2019 Learning...

  • Fill out the income statements for year 1 through year 3 FINC 3310 - Fall 2019...

    Fill out the income statements for year 1 through year 3 FINC 3310 - Fall 2019 N Learning Objectives on 1. Understand how to use EXCEL Spreadsheet 6 (a) Develop proforma Income Statement Using Excel Spreadsheet 7. (b) Compute Net Project Cashflows, NPV, and IRR 8 (c) Develop problem-solving and critical thinking skills and make long-term investment decisions 11 1) Life Period of the Equipment - 4 years 8) Sales for first year (1) $ 12 2) New equipment cost...

  • Please show work, don't give me an excel based response, thank you! Consider a capital expenditure project to purchase a...

    Please show work, don't give me an excel based response, thank you! Consider a capital expenditure project to purchase and install new equipment with an initial cash outlay of $25,000. The project is expected to generate net after-tax cash flows each year of $6800 for ten years, and at the end of the project, a one-time after-tax cash flow of $11,000 is expected. The firm has a weighted average cost of capital of 12 percent and requires a 3-year payback...

  • Important: Show your solutions! QUESTION 1: Consider the following two projects: Year Cash Flow (A) Cash...

    Important: Show your solutions! QUESTION 1: Consider the following two projects: Year Cash Flow (A) Cash Flow (B) -$364,000 -$52,000 25,000 46,000 68,000 22,000 68,000 21,500 458,000 17,500 Whichever project you choose, if any, you require a return of 11 percent on your investment. 1) Suppose these two projects are independent. Which project(s) should you accept based on: a. The Payback rule? Explain. (1096) b. The Profitability Index rule? Explain. (10%) c. The IRR rule? Explain. (10%) d. The NPV...

  • Project Evaluation: Your firm is contemplating the purchase of a new $800,000 computer-based order entry system....

    Project Evaluation: Your firm is contemplating the purchase of a new $800,000 computer-based order entry system. The system will be depreciated straight-line to zero over its four-year life. It will be worth $30,000 at the end of that time. You will save $230,000 before taxes per year in order processing costs, and you will be able to reduce working capital by $80,000 (this is a one-time reduction). If the tax rate is 25 percent, what is the IRR for this...

  • Revenues Expenses are generated by a new fad product are forecast as follows: Year Revenues 1...

    Revenues Expenses are generated by a new fad product are forecast as follows: Year Revenues 1 $65,000 2 $50,000 3 $40,000 4 $30,000 Thereafter 0 Expenses are expected to be 40% of revenues, and working capital required in each year is expected to be 20% of revenues in the following year. The product requires an immediate investment of $60,000 in plant and equipment. Required: a. What is the initial investment in the product? Remember working capital. b. If the plant...

  • Hi, Could you tell me why $60,000 of reduced in working capital is added in the...

    Hi, Could you tell me why $60,000 of reduced in working capital is added in the year 0? Thank you very much in advance! in COSIS, dllu mo m Toqun dll dl livestment in net working capital of 650 000. If the tax rate is 34 percent and the discount rate is 10 percent, what is the NPV of this project? 14. Project Evaluation IL art Evaluation ILO1] Your firm is contemplating the purchase of a new $425.000 computer-based order...

  • AAA Corp. currently has one​ product, high-priced lawn mowers. AAA Corp. has decided to sell a...

    AAA Corp. currently has one​ product, high-priced lawn mowers. AAA Corp. has decided to sell a new line of​ medium-priced lawn mowers. The building and machinery for producing this new line is estimated to cost ​$10 comma 000 comma 000 and it will be depreciated down to zero over 20 years using​ straight-line depreciation.​ Also, an investment today on working capital in the amount of ​$2 comma 000 comma 000 is needed. The working capital will be recovered at the...

  • 8. A project has an initial cost of $71,950, expected net cash inflows of $9,000 per...

    8. A project has an initial cost of $71,950, expected net cash inflows of $9,000 per year for 6 years, and a cost of capital of 10%. What is the project's PI? Do not round your intermediate calculations. Round your answer to two decimal places. 9. A project has an initial cost of $54,925, expected net cash inflows of $12,000 per year for 8 years, and a cost of capital of 11%. What is the project's payback period? Round your...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT