Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please help me with the formula to Test your skills with this problem and please show your work. Thanks Problem 1: Lin Land Ltd. (LLL)
Please help me with the formula to "Test your skills with this problem" and please show your work.
Thanks
Problem 1: Lin Land Ltd. (LLL) is considering investing in an apartment complex. The sale price is $450,000 and LLL expects to have positive after-tax cash flows from rents of $20,000 for the next three years. At the end of the third year, LLL anticipates Selling the apartment complex for a net after-tax gain on sale of $500,000. If LLL's required return is 15%, should LLL go ahead and purchase the apartment complex? Firace Concept: The nct present valuc rule states that accepting all projects that are worth more than they cost increase shareholder value. The decision rule is to accept all positive NPV projects. The internal rate of return on an investment is the rate that makes the NPV equal to scro. erica/ Solcioa: NPV = PV - required investment = PV cash flow.celling price - CF4/(1+r) + CFz/(1+r)* + CF,/(1+r)* + ATGS/(1+r) - SP = 20,000/1.15 +20,000/1.154 +20,000/1.159 +500,000/1.15' - 450,000 = 17,391 +15,123 +13,150 + 328,758 - 450000 = -75,578; decision do not accept the project Using Goal Seet: Let's find the required return that makes the NPV equal to acro. The cash flows are already entered for you from the inputs table. HPY & IRR Table: year cash flow lopets: 0 (450,000 Initial outla 450,000 1 20,000 CF 20,000 2 20,000 ATGS 500,000 3 520,000 23% NPY 10 Enter ENPV(G31,D29:D31)+D28 IRR 7.87% Enter: IRR(D28:D31) Using Goal Seck: Step 1. Make sure your computer has this option installed. If you can't install it on your own computer, feel free to use one of UTA's. Step 2. Go to the menu bar and hit Tools and then Goal Seck. Step 3. When the Goal Seck box appears fill in the inputs: set cell ===> enter D32, which is the NPV to value ===> enter 0, which is what we want NPV to be by changing ===> enter G31, which is the rate then hit the OK button Step 4. See the results. Goal Seck will change ther to make the NPV =0. This is also the IRR. Test your skills with this problem: What is the annual cash flow required to be to have the NPV = 0 and the IRR -15%? set cell ==> enter D32 to value ==> 0 by changing ==> CF (G29) $53, 101 is the onowerStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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