Relevant Cash Flows assignment

User Generated

Zvabhpur2017

Business Finance

Description

Complete and submit the RELEVANT CASH FLOWS WORK in the required format.

Income tax rate 30% Capital gains tax rate 15%

  1. You are considering investing in a new asset which costs $75,000. It will cost $5,000 to install this asset. The old asset, which has a book value of $0, can be sold for $25,000. The purchase price of the old asset was $100,000. The new asset will allow you to decrease your inventory by $2,000. What is the initial investment in this asset?
  2. If you purchase the new asset referred to in Problem 1, it will generate revenues of $60,000 per year for the next three years. Expenses will be $20,000 per year. The asset will be depreciated using the straight-line method. The operating cash flows for the old machine are $10,000 each year. What are the marginal operating cash flows for this investment?
  3. Continuing with the potential investment in Problems 1 and 2, at the end of year 3, the new asset will be sold for $50,000. What is the terminal cash flow for this investment?
  4. Based on the cash flows you calculated last week, find the NPV and IRR for this investment. Would you invest or not? Justify your answer.

***Required Format: you must submit your homework in an Excel file. Sheet 1 must contain nothing other than the problem number and your final answer. Sheet 2 must contain the calculations you used to arrive at your final answer.

Unformatted Attachment Preview

Complete and submit the RELEVANT CASH FLOWS WORK in the required format. Income tax rate 30% Capital gains tax rate 15% 1. You are considering investing in a new asset which costs $75,000. It will cost $5,000 to install this asset. The old asset, which has a book value of $0, can be sold for $25,000. The purchase price of the old asset was $100,000. The new asset will allow you to decrease your inventory by $2,000. What is the initial investment in this asset? 2. If you purchase the new asset referred to in Problem 1, it will generate revenues of $60,000 per year for the next three years. Expenses will be $20,000 per year. The asset will be depreciated using the straight-line method. The operating cash flows for the old machine are $10,000 each year. What are the marginal operating cash flows for this investment? 3. Continuing with the potential investment in Problems 1 and 2, at the end of year 3, the new asset will be sold for $50,000. What is the terminal cash flow for this investment? 4. Based on the cash flows you calculated last week, find the NPV and IRR for this investment. Would you invest or not? Justify your answer. Required Format: you must submit your homework in an Excel file. Sheet 1 must contain nothing other than the problem number and your final answer. Sheet 2 must contain the calculations you used to arrive at your final answer.
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hello. See the excel sheet attached. In case of anything else you can get back to me.

Final Answers
Question 1

Initial investment of the asset = $60,500

Question 2

Marginal operating cash flows of the new asset = $25,500

Question 3

Terminal Cash Flow = $37,000

Question 4

NPV = $38,956.97
IRR = 33%

Since NPV...


Anonymous
Nice! Really impressed with the quality.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags