DQ ou Chapter 9 HW Q Search Sheet Home Insert Page Layout Data Review View + Share A Formulas Connect ans Properties Libros Ed Links Az Clear Show Detail Sort From HIML Advanced Consolidate Flash Fill Text to Columns From New Database Refresh Text Query All . fx --G28 Remove Data Duplicates Validation Hina Detail Croup Ungroup Subtotal What if Analysis D28 E F H 1 K L M N P P 0 R $ T U W X Z A B Analyzing capa projects with the IRR methods Irmblem 1: Lin Land Ltd (LLL) is considering investing in an apartment complex. The sale price is $450,000 LLL expats to repitvo ter tax cash flows from reas or $20,000 to the next these years. At the end of the wind yox, LLL anticipates in the prime complex te atatert painon le or SSL.CD. Ir L.L.L'aquilidumia 15%, muld L.L.L. godhaluude the inciples 11 12 Fi.. Concu: The presaol vala: rulevale ile saping all pujasis tad are with man: then they are increaslochilar value. The daisie rule is to copt all positive projects. The imel taste of retum on an investment is the 12 Tule this makes the NPV qui too. 14 10 Maria Solution: 16 NPV- Pralinimal 17 Nah selling price 18 - CF X1 + r) + CF WCF Ytri - ATOSNI +rf - SP 19 20,000 1.15 +20,000.IS - 20,0001.15' - 300,000.IS' - 450,000 - 17.391 + 15,123 + 13,150 +225.758 - 400 21 - -25% derisinde mut seat the projet 23 List Gowork 24 Let's find the squired mix wukes the NPV qual to 20. 25 The cellow caly Giletelor le from the input dlu. 26 NPV & ERR Table 27 | you ol Lil cuiley 25 1 CF 30 21 ATGS 31 32 NPV Enter NPVIG3,029 D1HD2! 32 IRR Fela. IRRID2.Dan 34 35 ilsiry first tak: : 3F Step 1. Make sure your computer hiss this eptire installed if you can install 37 LE JOE Dw computer, ne tree to use ode of UTA'S. 3e Ste 2 Go to the mai duit Tould the Coal Seck 35 Sig. When the Chai Seck box upees fill the inpuls: 40 wader 1932, which is the NPV 41 to valo -->ter U.stoch is what we want NPV to be 42 Lydiuminkite G31, wide is the 49 til the Ohio 44 Step 4 See the mills. Cal Sak will conperher to make the NTV 45 This is also the UK 46 Test your skills with this problem: 47 Why is the tal cash flow request to be to be the NPVand the RR-15%? 40 Set odlater D32 wyd lay diuinkCF 29) 51 ssa, 101 is this is WLT. 52 NPV_criteria + Ready + 100% DQ ou Chapter 9 HW Q Search Sheet Home Insert Page Layout Data Review View + Share A Formulas Connect ans Properties Libros Ed Links Az Clear Show Detail Sort From HIML Advanced Consolidate Flash Fill Text to Columns From New Database Refresh Text Query All . fx --G28 Remove Data Duplicates Validation Hina Detail Croup Ungroup Subtotal What if Analysis D28 E F H 1 K L M N P P 0 R $ T U W X Z A B Analyzing capa projects with the IRR methods Irmblem 1: Lin Land Ltd (LLL) is considering investing in an apartment complex. The sale price is $450,000 LLL expats to repitvo ter tax cash flows from reas or $20,000 to the next these years. At the end of the wind yox, LLL anticipates in the prime complex te atatert painon le or SSL.CD. Ir L.L.L'aquilidumia 15%, muld L.L.L. godhaluude the inciples 11 12 Fi.. Concu: The presaol vala: rulevale ile saping all pujasis tad are with man: then they are increaslochilar value. The daisie rule is to copt all positive projects. The imel taste of retum on an investment is the 12 Tule this makes the NPV qui too. 14 10 Maria Solution: 16 NPV- Pralinimal 17 Nah selling price 18 - CF X1 + r) + CF WCF Ytri - ATOSNI +rf - SP 19 20,000 1.15 +20,000.IS - 20,0001.15' - 300,000.IS' - 450,000 - 17.391 + 15,123 + 13,150 +225.758 - 400 21 - -25% derisinde mut seat the projet 23 List Gowork 24 Let's find the squired mix wukes the NPV qual to 20. 25 The cellow caly Giletelor le from the input dlu. 26 NPV & ERR Table 27 | you ol Lil cuiley 25 1 CF 30 21 ATGS 31 32 NPV Enter NPVIG3,029 D1HD2! 32 IRR Fela. IRRID2.Dan 34 35 ilsiry first tak: : 3F Step 1. Make sure your computer hiss this eptire installed if you can install 37 LE JOE Dw computer, ne tree to use ode of UTA'S. 3e Ste 2 Go to the mai duit Tould the Coal Seck 35 Sig. When the Chai Seck box upees fill the inpuls: 40 wader 1932, which is the NPV 41 to valo -->ter U.stoch is what we want NPV to be 42 Lydiuminkite G31, wide is the 49 til the Ohio 44 Step 4 See the mills. Cal Sak will conperher to make the NTV 45 This is also the UK 46 Test your skills with this problem: 47 Why is the tal cash flow request to be to be the NPVand the RR-15%? 40 Set odlater D32 wyd lay diuinkCF 29) 51 ssa, 101 is this is WLT. 52 NPV_criteria + Ready + 100%