Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Use the following matrix to compute straight line depreciation for the following two scenarios: 1. Equipment cost of $120,000, sixyear useful life, no salvage value
Use the following matrix to compute straight line depreciation for the following two scenarios: 1. Equipment cost of $120,000, sixyear useful life, no salvage value and no trade in; and 2. Equipment cost of $120,000, sixyear useful life, no trade in, salvage value of $30,000. What is the dollar difference in annual depreciation between these two scenarios? Note: Your answer should contain both of the boxes below. No salvage: Annual Remaining Depreciation Balance Beginning Balance = $120,000 Annual Remaining Depreciation Balance Beginning Balance = $120,000 1 2 3 4 5 6 What is the internal rate of return (IRR) of a project with an initial outlay of $10,000, resulting in a free cash ow of $2,055 at the end of each year for the next 18 years? Please provide your submission in only MS Excel, identifying the IRR as a percent. Ensure that your IRR percentage is rounded to two decimal places
Step 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