User Account

All Pages

Reconcile the fcf valuation results

Assignment Help Financial Accounting
Reference no: EM131790724

FCF Valuation

Q1 - Mark Cartwright is trying to sell his business. He asked you, as a GW MBA, to value the business for him, so he can decide how to price it.

You ran two scenarios of the forecast, then you ran the FCF VALUATION MODEL for each scenario, A & B above.

Reconcile the two scenarios by examining their inputs and outputs, and recommend to Mark how much you think his business is worth.
Include a justification based on your analysis and reconcilation of the two scenarios. HINT: How do Scenario A&B assumptions (inputs) differ?

MARKET MULTIPLES (COMPARABLES) VALUATION OF EQUITY

Q1

After you finished the FCF Valuation (previous tab), you learned of a business similar to Cartwright Lumber that was sold recently to a new owner.

The data for that sale, a peer company, are already entered for you, in the Q2 Market Multiples template, cells B4.B7.
Interpret that analysis, following the steps explained in chapter 6.
Explain the results of your Market Multiples analysis in the box provided.

Q2
Reconcile the FCF Valuation results with the Market Multiples Valuation results. HINT: Use Summary at row 24.

Q3
Instead of the FCF Valuation and the Market Multiples Valuation, is it valid to use a simple capitalization formula,
such as the #2 formula on page 97 of the Cohen Finance Workbook?
Calculate the value of Cartwright using that formula and discuss the implications.

Q1: ROE, ROA, ROIC are given for Cartwright Lumber and Apex Lumber.

Read the Cohen Finance Book chapters 1 & 2, concentrating on the how-to's of ratio analysis in chapter 2.
If you need it, chapter 1 acts as an accounting refresher.

1a: Why is Cartwright ROE higher than Apex ROE? Is it better? Why? Why not? Write answer in box.

1b: Why is Cartwright ROA lower than Apex ROA? What does it tell you about the two companies? Write answer in box.

1c: How do the Cartwright & Apex ROICs compare? What does this suggest about the two companies? Write answer in box.

Q2: FINANCIAL STATEMENT ANALYSIS WITH RATIOS

1a: Using the ratios below, appraise the trend (2001-03) of Cartwright's liquidity. Cite specific ratios to justify your analysis.

1b: Using the ratios below, appraise the trend (2001-03) of Cartwright's leverage. Cite specific ratios to justify your analysis.
1c: Using the ratios below, appraise the trend (2001-03) of Cartwright's asset use (efficiency). Cite specific ratios to justify your analysis.
1d: Using the ratios below, appraise the trend (2001-03) of Cartwright's profitability. Cite specific ratios to justify your analysis.

1e: Interpret the DuPont Formula ratios by explaining if its four ratios are a valid substitute for the ratios in Q1a-1d above. Cite specifics.
1f: Appraise Cartwright's 'business risk'.

1g: Appraise Cartwright's 'financial risk'.
1h: Based on Cartwright's 2001-03 performance, make a qualitiative summary judgment about it.

Q1a
Discuss how the interest expense (row 25) calculation works and whether or not it includes the
short term borrowing on the Cartwright balance sheet. HINT: What is the source of
the data used in the ratio on row 14?

Q1b
How much does Cartwright need to borrow and when? Explain by citing specifics from the forecast.
Q1c
Does Cartwright have the ability to pay the interest expense? Explain by citing specifics from the forecast.
Q1d
Does Cartwright have the ability to repay the loan principal? Explain by citing specifics from the forecast.

Q2a
Explain how the p 45 table from the Cohen Finance Workbook, shown above starting on row 47, works and its
significance to Cartwright's (and most other businesses too) external financing needs problem.

Q2b
Revise the short-form forecast model from Q1, using the 'input cells zeroed' model at the top of this tab.
As the banker, assume a lower growth rate in sales, and explain, showing specifics from the revised forecast,
how it helps Cartwright solve his external financing needed problem. Enter revised data in the blue cells, using your judgment.

Attachment:- Template.xlsx

Reference no: EM131790724

Questions Cloud

Find the amount of output that can be produced : Q = 6LK w = $3, r = $1.5 The firm would like to know the maximum output that can be produced for $9,000. Find the combination of inputs that maximizes output.
Compute the basic and diluted eps : McManus Inc. reported net earnings of $400,000 for the year. McManus has 200,000 shares of common stock outstanding all year. Compute the basic and diluted EPS.
Define marketable securities : Define marketable securities ( also referred to as short- term investments). What characteristics of securities justify classifying them as financial assets
What is the income tax refund receivable : The Kelso Company had the following operating results, What is the income tax refund receivable
Reconcile the fcf valuation results : Reconcile the FCF Valuation results with the Market Multiples Valuation results - Calculate the value of Cartwright using that formula and discuss
What is the number of accidents caused by males : What is the standard deviation for the number of accidents caused by males between the ages of 19 and 34?
Identify three alternative application bases : The Determination of an appropriate overhead application rate is a crucial element in the computation of accurate product cost
Provide a concise statement in regards to your assessment : Provide a concise statement in less than forty words below in regards to your assessment of the appropriateness of the going concern basis for Panda Ltd.
Calculate the accounting and economics profits for the firm : Gomez runs a small pottery firm. He hires one helper at $12,000 per year, pays annual rent of $5,000 for his shop, and spends $20,000 per year on materials.

Reviews

Write a Review

Financial Accounting Questions & Answers

  What is a demand forecast

Would a labor hiring and training plan be more important in a university that is hiring faculty members, or a municipal government office that hires casual workers to do unskilled work? Why?

  What proportion of intragroup transactions eliminated

Where only a proportion of subsidiary's shares are owned by a parent entity, what proportion of the intragroup transactions between the parent entity and the subsidiary will need to be eliminated on consolidation?

  Acquisition was proportionate to amsterdam''s total fair

On June 30, 2015, Morey paid $560,000 for an additional 70 percent of Amsterdam, thus increasing its overall ownership to 95 percent. The price paid for the 70 percent acquisition was proportionate to Amsterdam's total fair value.

  Establish the taxable income under the formula approach

In January of 2013, SLU of Tampa created a simple trust. This simple trust received interest income in an amount of $4,500 on October 6th of 2016. According to the IRS, this interest income qualified as tax exempt. SLU of Tampa invested $100,000 in l..

  Post all journal entries and adjusting journal entries

Post all journal entries and adjusting journal entries to the general ledger T-accounts and ending balances of all permanent accounts to the beginning balances (BB) in July's general ledger T-accounts. Please round all amounts to the neares..

  Main reasons for the trend toward managing by numbers

What do you think are the main reasons for the trend toward “managing by numbers,” as discussed in the case? Do you believe this is happening in many organizations, or is it an isolated phenomenon? Will this trend grow in the future, or is it another..

  Production costs to each product using physical units method

Bubble Corporation manufactures two products, I and II, from a joint process. A single production costs $4,000 and results in 100 units of I and 400 units of II. To be ready for sale, both products must be processed further, incurring separable costs..

  Educational requirement to sit for the cpa exam

Develop a thorough understanding of accounting standards and principles and fulfill the core accounting educational requirement to sit for the CPA exam.

  Revenue growth trends and expense patterns

I am trying to learn more about a particular company's revenue growth trends and expense patterns. Specifically, I want to see how the company has grown and where it may have opportunities for future growth.

  Equity appear on publicly traded company financial statement

How would the owner's equity appear on a publicly traded company's financial statements? I work for a publicly traded company, so that is our primary source of investments. I know these financial statements are important for sole proprietorship, but ..

  What is the premise behind the equity method

What is the premise behind the equity method? Do the journal entries related to the equity method reflect what is really happening to the investment? Are the fair value method entries a better reflection of the investment?

  Compute the gain or loss on the sale

On January 2, 2016, Twilight Hospital purchased a $94,800 special radiology scanner from Bella Inc. The scanner had a useful life of 4 years and was estimated to have no disposal value at the end of its useful life. The straight-line method of deprec..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd