Section 2 - Valuation Frank and his brother, George, are thinking of starting their own company....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Section 2 - Valuation Frank and his brother, George, are thinking of starting their own company. The company will be a coffee shop, and the two brothers expect the initial investment to reach 500,000 SAR. If the project is actually implemented, the brothers will ask for a 300,000 SAR bank loan; the rest of the investment will be financed by their savings. The brothers estimate that the project's terminal value to be 650,000 SAR, at the end of 2025. The next table includes information concerning the project's capital structure and the cost of capital: Capital Structure Inputs: Risk-free rate Project's Beta Market's Expected Return Corporate Tax Rate Bank Loan interest rate The following tables exhibit various data from the projections carried-out by Frank and his brother: Income Statement - Projections Revenues from Sales Cost of Goods Sold Gross Profit General & Administrative Expenses EBITDA Depreciation & Amortization EBIT Interest Expenses Earnings Before Taxes Taxes (30%) Net Income Applicable to Shareholders Other Information Accounts Receivable Inventory Accounts Payable Investments Divestments 3% 0.9 13% 30% 5% Bank Loans-New Debt Bank Loans-Reimbursements 2023 350,000 140,000 210,000 65,000 145,000 100,000 45,000 5,400 39,600 11,880 27,720 2023 15,000 24,000 10,000 60,000 2024 400,000 160,000 240,000 72,000 168,000 100,000 68,000 3,600 64,400 19,320 45,080 2024 18,000 26,000 15,000 60,000 2025 420,000 168,000 252,000 80,000 172,000 100,000 72,000 1,800 70,200 21,060 49,140 2025 22,000 28,000 20,000 60,000 Using the Excel template provided to you (see the LMS platform), you need to: 2.1. Estimate the project's Cash-Flows applying the Free Cash-Flow to the Firm Method (FCFF). 2.2. Estimate the Weighted Average Cost of Capital (WACC). 2.3. Compute the project's Expected NPV according to the FCFF method. 2.4. Estimate the project's Cash-Flows applying the Free Cash-Flow to Equity Method (FCFE). 2.5. Compute the project's Expected NPV according to the FCFE method. 2.6. Using the FCFF approach, what is the project's expected Internal Rate of Return (IRR)? Section 2 - Valuation Frank and his brother, George, are thinking of starting their own company. The company will be a coffee shop, and the two brothers expect the initial investment to reach 500,000 SAR. If the project is actually implemented, the brothers will ask for a 300,000 SAR bank loan; the rest of the investment will be financed by their savings. The brothers estimate that the project's terminal value to be 650,000 SAR, at the end of 2025. The next table includes information concerning the project's capital structure and the cost of capital: Capital Structure Inputs: Risk-free rate Project's Beta Market's Expected Return Corporate Tax Rate Bank Loan interest rate The following tables exhibit various data from the projections carried-out by Frank and his brother: Income Statement - Projections Revenues from Sales Cost of Goods Sold Gross Profit General & Administrative Expenses EBITDA Depreciation & Amortization EBIT Interest Expenses Earnings Before Taxes Taxes (30%) Net Income Applicable to Shareholders Other Information Accounts Receivable Inventory Accounts Payable Investments Divestments 3% 0.9 13% 30% 5% Bank Loans-New Debt Bank Loans-Reimbursements 2023 350,000 140,000 210,000 65,000 145,000 100,000 45,000 5,400 39,600 11,880 27,720 2023 15,000 24,000 10,000 60,000 2024 400,000 160,000 240,000 72,000 168,000 100,000 68,000 3,600 64,400 19,320 45,080 2024 18,000 26,000 15,000 60,000 2025 420,000 168,000 252,000 80,000 172,000 100,000 72,000 1,800 70,200 21,060 49,140 2025 22,000 28,000 20,000 60,000 Using the Excel template provided to you (see the LMS platform), you need to: 2.1. Estimate the project's Cash-Flows applying the Free Cash-Flow to the Firm Method (FCFF). 2.2. Estimate the Weighted Average Cost of Capital (WACC). 2.3. Compute the project's Expected NPV according to the FCFF method. 2.4. Estimate the project's Cash-Flows applying the Free Cash-Flow to Equity Method (FCFE). 2.5. Compute the project's Expected NPV according to the FCFE method. 2.6. Using the FCFF approach, what is the project's expected Internal Rate of Return (IRR)?
Expert Answer:
Answer rating: 100% (QA)
Here are the calculations for valuation using FCFF and FCFE methods 21 F... View the full answer
Related Book For
Intermediate Financial Management
ISBN: 978-1285850030
12th edition
Authors: Eugene F. Brigham, Phillip R. Daves
Posted Date:
Students also viewed these finance questions
-
What is A ^ ( 2 0 2 4 ) v , Where A = [ [ 1 , 3 ] , [ 2 , 2 ] ] and v = [ 0 , 5 ]
-
The Coca-Cola Company is a global soft-drink beverage company that is a direct competitor with Starbucks. The data in Chapter 12, Exhibits 12.14 through 12.16 (pages 806-809), include the actual...
-
In Problem 10.16, we projected financial statements for Walmart Stores, Inc. (Walmart) for Years +1 through +5. The data in Exhibits 12.17-12.19 (pages 948-950) include the actual amounts for 2012...
-
State Newtons second law of motion. What are the limitations on the use of Newtons second law? Explain.
-
If A and B are both mutually exclusive and independent, then at least one of P(A) or P(B) must be zero. Assume A and B are events such that 0 < P(A) < 1 and 0 < P(B) < 1. Is this true or false?
-
ZanyBrainy Corporation makes interlocking children's blocks in a single processing department. Direct materials are added at the start of production. Conversion costs are added evenly throughout...
-
On July 1, Esquire Tables, Inc., began work on Job No. 309. The order is for 45 No. ET42 game tables for stock; date wanted is July 10. Instructions: 1. Open a cost sheet and record the transactions....
-
Listed below are several transactions that took place during the first two years of operations for the law firm of Pete, Pete, and Roy. In addition, you learn that the company incurred utility costs...
-
Demand for Quiggly Pops follows an up and down pattern over the four quarters of a year, with peaks in the spring and winter months when special promotions are held. Production is handled by a highly...
-
A collar B, of mass m and negligible dimensions, is attached to the rim of a hoop of the same mass m and of radius r that rolls without sliding on a horizontal surface. Determine the angular velocity...
-
The following unit step response curves come from linear systems that have each either one pole or two poles and no zeros. Identify the model of each system. That is, for a first order system find...
-
what manner does the cognitive phenomenon of perspicacity manifest within the labyrinthine corridors of human comprehension, thereby engendering a profound clarity that transcends the bounds of...
-
You are a contestant on the game show Deal or No Deal .In this game show, you are given the choice of opening boxes in succession.The last box you open is the prize you take home.Alternatively, the...
-
In a gas turbine, the working substance can usually be approximated to behave like an ideal gas. The pressure and temperature at the inlet of the turbine are p1 and T1, and at the outlet, the...
-
Both firms are unlevered firms, and the cost of capital is 11.5%. The corporate tax rate is 35%. After the merger, production capacity will be enhanced from 4M unit of output to 10M, while the sales...
-
Sara is working with Dunbay Construction Inc as administrator assistant. She is an hourly employee and receives her salary biweekly. Her hourly rate is $28. She works 78 hours each pay period. She...
-
I'm a intern at Lawrence Hall as child care specialist this week I did home visit and Supervision visit it was very nice watching the one year Bondy with her father, but still having moments when she...
-
Find the equations of the ellipses satisfying the given conditions. The center of each is at the origin. Passes through (2, 2) and (1, 4)
-
The rate of return on a bond held to its maturity date is called the bond's yield to maturity. If interest rates in the economy rise after a bond has been issued, what will happen to the bond's price...
-
a. Assume that, on average, the brothers expect annual sales of 18,000 items at an average price of $100 per item. (use a 365 day year.) (1) What is the firm's expected days sales outstanding (DSO)?...
-
Start with the partial model in the file Ch19 P06 Build a Model.xls on the textbook's Web site. As part of its overall plant modernization and cost reduction program, Western Fabrics' management has...
-
Kate Miller owns a dance studio in Los Angeles, California. Students can buy access to the dance classes by paying a monthly fee. Unfortunately, many of Kates students are struggling actors and...
-
Global Markets, Inc. was experiencing a shortage of cash. Consequently, the President was considering two options to provide an immediate inflow of cash. The first option was to sell \($2\) million...
-
Star Communications designs, manufactures, and sells telecommunication equipment, and provides services associated with their installation, operation, and maintenance in China, India, Korea, and...
Study smarter with the SolutionInn App