With the assumptions below, create a Proforma and 10 year Discounted Cash Flow model based on the
Fantastic news! We've Found the answer you've been seeking!
Question:
With the assumptions below, create a Proforma and 10 year Discounted Cash Flow model based on the following assumption and answer the questions below.
Transcribed Image Text:
Assume to cost of capital for the equity portion of the capital stack is 25% and the corporate tax rate is 21%. What is the weighted average cost of capital (WACC)? 2. What is the approximate Debt Service Coverage Ratio at the end of year 7? 3. What are the approximate percentages of present value allocated between leveraged cash flow from operations and leveraged cash flow from sale, respectively? (i.e., PV Ops and PV Sale). Assume a discount rate of 20% 4. In what year is the total amount of the initial equity investment returned using the levered free cash flow (i.e., in what year is the cumulative levered free cash flow first positive)? 5. At a 20% levered discount rate, should the project be accepted? 6. What is the approximate total undiscounted sum of cash flow from operations? 7. What is the approximate primary loan payoff value in year 10? 8. What is the approximate gross sale value in year 10? 9. What is the maximum leveraged discount rate you can use in order to accept this deal based on the Net Present Value criterion? 10. Assuming all other inputs remain as modeled in the write up instructions, rank the following options shown below from highest to lowest increase to NPV? a. Decreasing the NPV discount rate from 20% to 15% b. Increasing the Year over Year rent escalation from 3% to 5% c. Extending the primary loan from 20 years to 30 years d. Increasing the bank LTV from 70% to 90% e. Decreasing the spread on the exit cap from +150bps to zero bps Assume to cost of capital for the equity portion of the capital stack is 25% and the corporate tax rate is 21%. What is the weighted average cost of capital (WACC)? 2. What is the approximate Debt Service Coverage Ratio at the end of year 7? 3. What are the approximate percentages of present value allocated between leveraged cash flow from operations and leveraged cash flow from sale, respectively? (i.e., PV Ops and PV Sale). Assume a discount rate of 20% 4. In what year is the total amount of the initial equity investment returned using the levered free cash flow (i.e., in what year is the cumulative levered free cash flow first positive)? 5. At a 20% levered discount rate, should the project be accepted? 6. What is the approximate total undiscounted sum of cash flow from operations? 7. What is the approximate primary loan payoff value in year 10? 8. What is the approximate gross sale value in year 10? 9. What is the maximum leveraged discount rate you can use in order to accept this deal based on the Net Present Value criterion? 10. Assuming all other inputs remain as modeled in the write up instructions, rank the following options shown below from highest to lowest increase to NPV? a. Decreasing the NPV discount rate from 20% to 15% b. Increasing the Year over Year rent escalation from 3% to 5% c. Extending the primary loan from 20 years to 30 years d. Increasing the bank LTV from 70% to 90% e. Decreasing the spread on the exit cap from +150bps to zero bps
Expert Answer:
Answer rating: 100% (QA)
Creating a Proforma and 10year Discounted Cash Flow DCF model based on the provided assumptions is a complex financial analysis that requires detailed calculations and assumptions for various variable... View the full answer
Related Book For
Advanced Accounting
ISBN: 978-0538480284
11th edition
Authors: Paul M. Fischer, William J. Tayler, Rita H. Cheng
Posted Date:
Students also viewed these corporate finance questions
-
In general, students are expected to meet the following objectives: 1) To ascertain cost of capital for a new project by using cost of capital of existing firms operating in the same business. (2)...
-
FREE-CASH-FLOWS-BASED VALUATION. In Problem, we projected financial statements for Wal-Mart Stores, Inc. (Walmart) for Years +1 through +5. The data in Exhibits 13 (see pages 985987) include the...
-
In Problem, we projected financial statements for Wal-Mart Stores, Inc. (Walmart) for Years +1 through +5. The data in Exhibits 13 (see pages 985987) include the actual amounts for 2008 and the...
-
Fill the blanks of the following table (last column) and find out the value of SDR in terms of U.S. dollars ($/SDR) and the value of U.S. dollars in terms of SDR (SDR/$) The exchange rate is...
-
A heat exchanger consists of a bank of 1200 thin-walled tubes with air in cross flow over the tubes. The tubes are arranged in-line, with 40 longitudinal rows (along the direction of airflow) and 30...
-
Why do we not notice the effects of billions of neutrinos passing through each square centimeter of our body surface every second?
-
It is estimated that air pollution is responsible for 1.1 million deaths annually in China. Heavy reliance on coal to fuel the production of electricity combined with rapid industrialization have...
-
Presented below and on page 740 are three independent situations. 1. Hairston Stamp Company records stamp service revenue and provides for the cost of redemptions in the year stamps are sold to...
-
One key feature of Sage 50 Accounting software, it implements user access controls to restrict access to sensitive financial data. Maintain the security of financial information with password...
-
Three entrepreneurs were looking to start a new brewpub near Sacramento, California, called Roseville Brewing Company (RBC). Brewpubs provide two products to customersfood from the restaurant segment...
-
You need to write a sample e-mail to Gavin Stead - Managing Director (assessor), specifying that you have completed the weekly sale report and chart spreadsheet
-
Give two differences and two similarities between direct marketing objectives and general marketing objectives.
-
What are the overlaps between relationship and direct marketing? In what ways do the two approaches to marketing differ?
-
Explain the vertical integration options. and directions for the following providers: (a) a major academic medical center such as the University of Iowa, (b) a five-person general surgery group, and...
-
Tour operators selling package holidays often do very little in persuading previous customers to return for another trip. As a consultant, offer advice on customer retention and revenue maximisation...
-
Robbinsdale Hospital is one of two hospi- tals among the six facilities in the city to have an intensive care (Level III) nursery. This facility is tailored to treat infants suf-. fering from severe...
-
CASE Study 1Jonesin for a New Market Being a small company has its advantagesexcept in the cutthroat world of soft drink manufacturing. Behemoths like Coke and Pepsi have consistently had their way...
-
Prove that the mean heat capacities C P H and C P S are inherently positive, whether T > T 0 or T < T 0 . Explain why they are well defined for T = T 0 .
-
The audit of Barns Company and its subsidiaries for the year ended December 31, 2012, is completed. The working papers contain the following information: a. Barns Company acquires 4,000 shares of...
-
What is the special concern over accounting for medical malpractice claims? How does accounting for such claims compare to accounting for contingencies in a for profit business environment?
-
Assume Round Rock City has the following fund structure: General fund Special revenue fund (3) Capital projects fund (2) Debt service fund (3) Expendable trust funds (5) Internal service funds (2)...
-
Powerhouse Ltd purchased machinery on 2 January 2019, at a cost of $800 000. The machinery is depreciated using the straightline method over a useful life of 8 years with a residual value of $80 000....
-
The purchases and sales of Big Flower Pty Ltd of one brand of lawn fertiliser for the year ended 31 December 2019 are contained in the schedule below. The selling price up to 30 June was $12 per unit...
-
In groups of four or five, consider the following information. On 1 July 2019, Stevenson Pty Ltd, a proprietary company with three shareholders, acquired some property by issuing 100 000 shares to...
Study smarter with the SolutionInn App