Please fill in thr blank on the excel and show how you got the missing things. ICXV fxDEFGHcome Statemenтегантто топиш поIncomeYearEBITTaxNet IncomeDep and AmortOCFPV of planning periodPerpetual growth terminal valuePV of terminal valueEnterprise value (V)E (= V-D)assume in thousands of dollarsPlanning periodKLAssumptionsM201420152016201720182019WACC =5%398447508567624151.24169.86193.04215.46237.12669254.22LT growth rate =5.3%MV of debt =246.76277.14314.96351.54289317339345386.88353414.78Tax RATE =369535.76594.14653.96696.54739.88783.781+

The provided information appears to be the beginning of a financial model for a company, likely used…

Answered: IC XV fx D E F G H come Statemen…

Survey of Accounting (Accounting I)

8th Edition

ISBN:9781305961883

Author:Carl Warren

Publisher:Carl Warren

Chapter15: Capital Investment Analysis

Section: Chapter Questions

Problem 15.1.1MBA

See similar textbooks

Similar questions

Spreadsheet Link What is the IRR of the following project?Cash FlowYear0 -32,0001. 9,0002. 10,0003. 15,0004. 7,800 1). 10.8% 2). 11.2% 3). 11.7%4). 12.0% 5). 12.3%
Following is information on two alternative investments being considered by Jolee Company. The company requires a 8% return from its investments. (PV of $1, FV of $1. PVA of $1, and FVA of $1) (Use appropriate factor(s) from the tables provided.) Initial investment Expected net cash flows in: Year 1 Year 2 Year 3 Year 4 Year 5 Required A Required B Project A $(183,325) a. For each alternative project compute the net present value. b. For each alternative project compute the profitability index. If the company can only select one project, which should it choose? Initial Investment $ Chart Values are Based on: i=P % 45,000 58,000 78,295 87,400 60,000 Complete this question by entering your answers in the tabs below. For each alternative project compute the net present value. Project A 183,325 Project B $(143,960)
Determine the ERR (External rate of return) of the cash flows if external rate (e) is given as %10. Cash Flow Year 0 1 2 3 4 5 6 7 Select one: a.0.245007 b.0.19667 c.0.168017 d.0.204146 e.0.274516 f.0.181262 g.0.228861 h.0.264278 -3000 3000 6000 -1000 2000 4000 -5000 8000
How to find the minimum certainty equivalent adjustment? PV cash flow at 10% PV: 122,891 Net: 2,891 i: 10
Single Cash Flow Future Value Inputs Single Cash Flow Discount Rate/Period 747.25 6.00% Number of Periods Future Value using a Time Line Period 2 3 4 Cash Flows Future Value of Each Cash Flow Future Value Future Value using the Formula Future Value Future Value using the FV Function Future Value
onsider the following cash flows: C0=-$42 C1=+$38 C2=+$38 C3=+$38 C4=-$76 a. Which two of the following rates are the IRRs of this project?
Calculate the APR of the following investment, entered as a percentage (Example: if your answer is 14.5%, enter 14.5 and not 0.145) Year Number Cashflow 0 -11000 1 3000 2 3500 3 2900 4 2800
The cash flow streams for three alternative investment A, B, C andD are: Project Со Cash Flow (Tk.) C1 C2 C3 C4 C5 C6 A 230000 55000 45000 65000 45000 75000 50000 В 290000 45000 90000 35000 95000 65000 55000 310000 75000 55000 60000 55000 65000 45000 D 350000 77000 75000 95000 85000 65000 Determine (i) Pay Back Period, (ii) NPV if the required rate of return is 11%, and (ii) IRR for the four alternatives.
Q2. Compute the rate of return on the investment characterized by the following cash flow. Year 0 1 3 4 S Cash Flow -$50.0 +20.0 -40 +36.8 +36.8 +368
The cash flow streams for three alternative investment A, B, C and D are: Project Co 230000 Cash Flow (Tk.) C2 C3 C4 Cs C6 50000 A 55000 45000 65000 45000 75000 В 290000 45000 90000 35000 95000 65000 55000 310000 75000 55000 60000 55000 65000 45000 D 350000 77000 75000 95000 85000 65000 Determine (i) Pay Back Period, (ii) NPV if the required rate of return is 11%, and (ii) IRR for the four alternatives.
Can I please have the answers in these format : payback period = investement net annual inflow ARR = Average annual profit x 100 Average investment 1 can I have the answers in these type of format
Module 02 Written Assiqnment Application of Future Value and Present Value.xlsx - OpenOffice Calc File Edit View Insert Format Iools Data Window Help ABC 《的, ABC Verdana 10 В I U 三開 % 0 □ A B G H I 1. Assume an investment of $2,000 today. Calculate the FV of the investment according to eac 6. 7 a. 6 percent compounded annually 8 9. Rate 6% 10 Nper PMT 12 11 12 PV $2,000.00 $0.00 13 FV 14 15 b. 8 percent compounded annually 16 17 Rate 8% 18 Nper 12 19 PMT 20 PV $2,000.00 21 FV 22 23 c. 10 percent compounded annually 24 25 Rate 10% 26 Nper 12 27 PMT 28 PV $2,000.00 29 FV 30 31 d. 10 percent compounded semiannually 32 Rate K Future Value Present Value 33 10% STD Sheet 1/2 PageStyle Future Value

SEE MORE QUESTIONS

Recommended textbooks for you

Survey of Accounting (Accounting I)

Accounting

ISBN:

9781305961883

Author:

Carl Warren

Publisher:

Cengage Learning

Corporate Fin Focused Approach

Finance

ISBN:

9781285660516

Author:

EHRHARDT

Publisher:

Cengage

Survey of Accounting (Accounting I)

Accounting

ISBN:

9781305961883

Author:

Carl Warren

Publisher:

Cengage Learning

Corporate Fin Focused Approach

Finance

ISBN:

9781285660516

Author:

EHRHARDT

Publisher:

Cengage

SEE MORE TEXTBOOKS