must show work in excel - need question #4

Data Dett/Touty of propert TE Leveredet Debt IR. PMT 40debant of 185m 2015 15 $ 957 retiring at the end of your 8 5119 YEAR 1 UCH -105m 5.7 m 9.59 m Cakuiste Value of the Project. What would haven if there is a flotation cost? Hinta 1. APVNPV (UCF) to NPV Financing at 2. R5 RD/ 5D- R1-19 3. NPV debt financing Proceeds - Altertas Pinterest Payments - Principal Payments 4. Cach year, an equal principal payment will be made which will reduce the interest scored during the Given a row level (AMT) of debt, debt cash flow should be discounted the debt 6 Use AP if the project level of debts over the life of the project the WACC FIL projectes images at vero e of the project Use?? because the level of debt for the project is known throughout the APV . NPV (UCF) at Ro NPV (Financing at RB A Find NVC dented to RRO-ACTO Me PUC YEAR 0 1 2 3 UO 115 5. 9.59 8.99 NIV 2. Find PV det financing NPV debt financing Proceeds - Ahertax Pinterest Payments - Prince Part Aftertax Pinterest Payments YLAR PUTER a blanca PG 1 5 PV of Abertas Personen 5 b. Principal Payment Heyment.com TPV 2 Principalmente Chiw (deut. Financing Proceeds - Ahertas Pinterest Payments) - Principal Payments NPV debt financing - 59 1. APVNPV/UCF) TopVacing 13- 4. In the event there are otion cost, then Total flotation contonanoat fatis cat The Annual floation cost will be 2 67 NPVLoan Proceeds net of flotation costs - Aftertas para internet and principale Costed Data Dett/Touty of propert TE Leveredet Debt IR. PMT 40debant of 185m 2015 15 $ 957 retiring at the end of your 8 5119 YEAR 1 UCH -105m 5.7 m 9.59 m Cakuiste Value of the Project. What would haven if there is a flotation cost? Hinta 1. APVNPV (UCF) to NPV Financing at 2. R5 RD/ 5D- R1-19 3. NPV debt financing Proceeds - Altertas Pinterest Payments - Principal Payments 4. Cach year, an equal principal payment will be made which will reduce the interest scored during the Given a row level (AMT) of debt, debt cash flow should be discounted the debt 6 Use AP if the project level of debts over the life of the project the WACC FIL projectes images at vero e of the project Use?? because the level of debt for the project is known throughout the APV . NPV (UCF) at Ro NPV (Financing at RB A Find NVC dented to RRO-ACTO Me PUC YEAR 0 1 2 3 UO 115 5. 9.59 8.99 NIV 2. Find PV det financing NPV debt financing Proceeds - Ahertax Pinterest Payments - Prince Part Aftertax Pinterest Payments YLAR PUTER a blanca PG 1 5 PV of Abertas Personen 5 b. Principal Payment Heyment.com TPV 2 Principalmente Chiw (deut. Financing Proceeds - Ahertas Pinterest Payments) - Principal Payments NPV debt financing - 59 1. APVNPV/UCF) TopVacing 13- 4. In the event there are otion cost, then Total flotation contonanoat fatis cat The Annual floation cost will be 2 67 NPVLoan Proceeds net of flotation costs - Aftertas para internet and principale Costed