*Data given is in blue and calculated numbers are in red.
Chapter 4 - Section 4
External Financing and Growth
External financing needed and growth are related, but we would like to examine that relationship. Below we have the financial statements for the
*Data given is in blue and calculations are in red
Chapter 3 - Section 3
Ratio Analysis
To compare the performance of companies, rather than compare the financial statements,
financial ratios are often used. Ratios are divided into categories based on wha
*Data given is in blue and calculations are in red
Chapter 3 - Section 4
The Du Pont Identity
The three-factor Du Pont equation separates the ROE into 3 components. For Prufrock, the three-factor Du Pont equation is:
ROE =
ROE =
ROE =
Profit margin
Total
*Data given is in blue and calculated numbers are in red.
Chapter 4 - Section 3
The Percentage of Sales Approach
Below, we have the financial statements for Rosengarten Corporation. Notice, we have an input cell for the tax rate since it is possible that
*Data given is in blue and calculations are in red
Chapter 3 - Section 5
Using Financial Statement Information
Financial ratio analysis is very much a management by exception tool. When you are analyzing ratios, a number by itself tells you very little. H
*Data given is in blue and calculations are in red
Chapter 3 - Section 2
Standardized Financial Statements
Although we usually don't like to repeat numbers from previous worksheets, we will show the
balance sheet here again:
Prufrock Corporation
2011 and
Chapter 2 - Section 1
The Balance Sheet
Spreadsheets are a very useful way to do financial calculations. Throughout these spreadsheets,
we will use Excel to perform most of the calculations that are presented in the textbook.
However, using Excel or any s
*Data given is in blue and calculations are in red
Chapter 3 - Section 1
Cash Flow and Financial Statements: A Closer Look
Below, we have the balance sheets for Prufrock Corporation. Each account also has a
calculation column to show the change in that ac
Chapter 2 - Section 4
Cash Flow
Now we are ready to calculate the financial cash flows for the fictitious U.S. Corporation. When
we calculate the cash flows, we are going to reference inputs and calculations from the previous
worksheets so we do not have
Chapter 2 - Section 3
Taxes
The corporate income tax table currently in effect is:
Taxable
income is
greater than
or equal
to.
$50,001
75,001
100,001
335,001
10,000,001
15,000,001
18,333,334
But
less
than or equal
to
$50,000
75,000
100,000
335,000
10,000,