ADM3318- Final Exam Guide - Comprehensive Notes for the exam ( 119 pages long!)
Get access
Related Documents
Related Questions
Can someone help with this case please, and:
Fill in all the blanks spaces in the spreadsheet for the 2017 column and the 2017 %rev column
Balance the B/S
Answer all questions in full sentence format
Please put in the correct number for forecasted PP&E based on narrative (I highlighted the phrase in the narrative)
Show work for how you calculated the forecasted interest for 2017.
Thank you so much for all your help.
Q.
After the financial analysis based on 2016 preliminary estimates was completed, a number of changes were adopted to improve financial and business results for S&S Air during 2016. The customer that awarded the large 40 aircraft order agreed to make interim payments as finished aircraft were delivered (for a price concession). Revenue was revised up slightly due to updated marketing plans. Expenses were trimmed and controls were established that greatly reduced on hand inventory needs. A portion of the line of credit was converted to a 5 year, fixed rate loan. Cash on hand and general liquidity was forecasted to improve to acceptable levels by the end of the year.
Mark and Marie approached Chris about creating a forecast for 2017. They had learned the value of the financial analysis done for 2016 and wanted to get a look at any issues or problems that might be looming in the future. Of particular concern was the continuing need for external funds as the firm continued to grow. The general consensus of Mark and Marie was that S&S Air should realize an increase in revenue of 17% in 2017 from the 2016 results, based on anticipated demand of aircraft. It was felt expenses would change by the same percent of sales as incurred in 2016. However, it was estimated that annual depreciation in 2017 would increase 70% (to a total of $1,075,000), due to the substantial increase in assets that were going to be needed. Finally, Chris said that her banking contract indicted that interest expense should be about 8% of both notes payable and long term debt in 2017.
By the end of 2016, the firm would be operating at capacity; it was estimated that further growth in 2017 would require $6,500,000 (including all depreciation – that is, adding $6.5 million to the 2016 Net PP&E to derive PP&E for 2017) in plant upgrades and additions to meet anticipated production volume. Everyone felt that all other asset categories (including cash) and current liabilities (including the line of credit) would change by percent of revenue. Both owners were concerned about where any needed external financing would come from. Neither was interested in raising any further equity, and agreed that they would likely secure long term financing for any external funds needed. The plan was to pay dividends totaling $400,000 in 2017.
Chris knew that a key exhibit would be the forecast mode. She planned to set up the model so that a key input would be the sales growth forecast. The “plug” to reconcile the balance sheet would be long term debt.
Q U E S T I O N S (please use full sentences)
1) Completed forecast model. Fill in all blanks for the 2017 and 2017 % of rev columns.
2) Compare PM, ROA, and ROE from 2016 to 2017. Why the differences?
3) Compare debt ratios from 2016 to 2017. Why the differences?
4) Compare total asset turnover from 2016 to 2017. Why the difference? What observations can you make regarding capacity utilization from 2016 to 2017?
5) Estimate the maximum revenue possible given the new level of assets in 2017, based on TATO in 2016 (at full capacity).
6) If COGS could be decreased by 1% of revenue, how much increase in EBIT would result? Express the change in EBIT in both dollar terms and % change.
7) Do a DuPont analysis on S&S Air for both 2016 and 2017. If the owners asked you for any issues or concerns about the basic results forecasted for 2017, what would you tell them? Consider operating, investing, and financing issues.
7a) Operating comments:
7b) Investing comments:
7c) Financing comments:
Income statement | 2016 | % rev | 2017 | % rev | ||
Sales | $21,566,000 | 100.0% | 17%% | |||
COGS | 14,786,000 | 68.6% | % of rev | 68.6% | ||
Other expenses | 2,375,000 | 11.0% | % of rev | 11.0% | ||
Depreciation | 625,000 | 2.9% | given | 1,075,000 | ||
EBIT | 3,780,000 | 17.5% | calc | |||
Interest | 437,000 | 2.0% | given | 8.0% | ||
Taxable income | 3,343,000 | 15.5% | calc | |||
Taxes (40%) | 1,337,200 | 6.2% | calc TI * tax rate | 40.0% | ||
Net income | 2,005,800 | 9.3% | calc | |||
Dividends | 375,000 | 1.7% | given | 400,000 | ||
Add to RE | 1,630,800 | 7.6% | calc |
B A L A N C E S H E E T | ||||||
2016 | % rev | 2017 | % | |||
Current Assets | ||||||
Cash | 425,000 | 2.0% | % of rev | 2.0% | ||
Accounts rec. | 855,000 | 4.0% | % of rev | 4.0% | ||
Inventory | 689,000 | 3.2% | % of rev | 3.2% | ||
Total CA | 1,969,000 | 9.1% | calc | |||
Fixed assets | ||||||
Net PP&E | 9,873,000 | 45.8% | given | 6,500,000 | ||
Total Assets | 11,842,000 | 54.9% | calc | |||
Current Liabilities | ||||||
Accounts Payable | 727,000 | 3.4% | % of rev | 3.4% | ||
Notes Payable | 1,467,000 | 6.8% | % of rev | 6.8% | ||
Total CL | 2,194,000 | 10.2% | calc | |||
Long-term debt | 2,908,800 | 13.5% | PLUG | |||
TOTAL CL + LTL | 5,102,800 | |||||
Shareholder Equity | ||||||
Common stock | 120,000 | 0.6% | no change | |||
Retained earnings | 6,619,200 | 30.7% | +2017 RE | |||
Total Equity | 6,739,200 | 31.2% | calc | |||
Total L&E | 11,842,000 | 54.9% | calc |
Ratio Analysis | ||
2016 | 2017 | |
PM | ||
ROA | ||
ROE | ||
Debt / Equity | ||
Debt / Total Assets | ||
Equity Multiplier | ||
Total Asset TO |
Thank you
NIKE:
Need the following ratios to be calculated using the financial sheets copied at the bottom. Each ratio needs to be calculated using the information from 2016. Each ratio also needs to be broken down and illustrated by the step by step process. Finally, please include any and all observations for each ratio and analysis.
1) Common Size analysis
2) Common size vertical analysis & graph
3) Current Ratio
4) Quick Ratio
5) Cash Ratio
6) Inventory Turnover
7) Receivables Turnover
8) Total Asset Turnover
9) Fixed Asset Turnover
10) Gross profit margin
11) Operating Profit margin
12) Net profit margin
13) Return on total assets
14) return on equity
15) basic earning power
16) Deb/net worth ratio
17) debt ratio
18) DuPont System
19) Times-interest-earned
Balance Sheet:
Consolidated Balance Sheets - USD ($) $ in Millions | May 31, 2017 | May 31, 2016 |
Current assets: | ||
Cash and equivalents | $ 3,808 | $ 3,138 |
Short-term investments | 2,371 | 2,319 |
Accounts receivable, net | 3,677 | 3,241 |
Inventories | 5,055 | 4,838 |
Prepaid expenses and other current assets | 1,150 | 1,489 |
Total current assets | 16,061 | 15,025 |
Property, plant and equipment, net | 3,989 | 3,520 |
Identifiable intangible assets, net | 283 | 281 |
Goodwill | 139 | 131 |
Deferred income taxes and other assets | 2,787 | 2,422 |
TOTAL ASSETS | 23,259 | 21,379 |
Current liabilities: | ||
Current portion of long-term debt | 6 | 44 |
Notes payable | 325 | 1 |
Accounts payable | 2,048 | 2,191 |
Accrued liabilities | 3,011 | 3,037 |
Income taxes payable | 84 | 85 |
Total current liabilities | 5,474 | 5,358 |
Long-term debt | 3,471 | 1,993 |
Deferred income taxes and other liabilities | 1,907 | 1,770 |
Commitments and contingencies | ||
Redeemable preferred stock | 0 | 0 |
Shareholders’ equity: | ||
Capital in excess of stated value | 8,638 | 7,786 |
Accumulated other comprehensive (loss) income | (213) | 318 |
Retained earnings | 3,979 | 4,151 |
Total shareholders’ equity | 12,407 | 12,258 |
TOTAL LIABILITIES AND SHAREHOLDERS’ EQUITY | 23,259 | 21,379 |
Class A Convertible Common Stock | ||
Shareholders’ equity: | ||
Common stock at stated value | 0 | 0 |
Class B Common Stock | ||
Shareholders’ equity: | ||
Common stock at stated value | $ 3 | $ 3 |
Income Statement:
Consolidated Statements of Income - USD ($) $ in Millions | 12 Months Ended | ||
May 31, 2017 | May 31, 2016 | May 31, 2015 | |
Income Statement [Abstract] | |||
Revenues | $ 34,350 | $ 32,376 | $ 30,601 |
Cost of sales | 19,038 | 17,405 | 16,534 |
Gross profit | 15,312 | 14,971 | 14,067 |
Demand creation expense | 3,341 | 3,278 | 3,213 |
Operating overhead expense | 7,222 | 7,191 | 6,679 |
Total selling and administrative expense | 10,563 | 10,469 | 9,892 |
Interest expense (income), net | 59 | 19 | 28 |
Other (income) expense, net | (196) | (140) | (58) |
Income before income taxes | 4,886 | 4,623 | 4,205 |
Income tax expense | 646 | 863 | 932 |
NET INCOME | $ 4,240 | $ 3,760 | $ 3,273 |
Earnings per common share: | |||
Basic (in dollars per share) | $ 2.56 | $ 2.21 | $ 1.90 |
Diluted (in dollars per share) | 2.51 | 2.16 | 1.85 |
Dividends declared per common share (in dollars per share) | $ 0.70 | $ 0.62 | $ 0.54 |
Cash Flow Sheet
Consolidated Statements of Cash Flows - USD ($) $ in Millions | 12 Months Ended | ||
May 31, 2017 | May 31, 2016 | May 31, 2015 | |
Cash provided by operations: | |||
Net income | $ 4,240 | $ 3,760 | $ 3,273 |
Income charges (credits) not affecting cash: | |||
Depreciation | 706 | 649 | 606 |
Deferred income taxes | (273) | (80) | (113) |
Stock-based compensation | 215 | 236 | 191 |
Amortization and other | 10 | 13 | 43 |
Net foreign currency adjustments | (117) | 98 | 424 |
Changes in certain working capital components and other assets and liabilities: | |||
(Increase) decrease in accounts receivable | (426) | 60 | (216) |
(Increase) in inventories | (231) | (590) | (621) |
(Increase) in prepaid expenses and other current assets | (120) | (161) | (144) |
(Decrease) increase in accounts payable, accrued liabilities and income taxes payable | (364) | (889) | 1,237 |
Cash provided by operations | 3,640 | 3,096 | 4,680 |
Cash used by investing activities: | |||
Purchases of short-term investments | (5,928) | (5,367) | (4,936) |
Maturities of short-term investments | 3,623 | 2,924 | 3,655 |
Sales of short-term investments | 2,423 | 2,386 | 2,216 |
Investments in reverse repurchase agreements | 0 | 150 | (150) |
Additions to property, plant and equipment | (1,105) | (1,143) | (963) |
Disposals of property, plant and equipment | 13 | 10 | 3 |
Other investing activities | (34) | 6 | 0 |
Cash used by investing activities | (1,008) | (1,034) | (175) |
Cash used by financing activities: | |||
Net proceeds from long-term debt issuance | 1,482 | 981 | 0 |
Long-term debt payments, including current portion | (44) | (106) | (7) |
Increase (decrease) in notes payable | 327 | (67) | (63) |
Payments on capital lease and other financing obligations | (17) | (7) | (19) |
Proceeds from exercise of stock options and other stock issuances | 489 | 507 | 514 |
Excess tax benefits from share-based payment arrangements | 177 | 281 | 218 |
Repurchase of common stock | (3,223) | (3,238) | (2,534) |
Dividends — common and preferred | (1,133) | (1,022) | (899) |
Cash used by financing activities | (1,942) | (2,671) | (2,790) |
Effect of exchange rate changes on cash and equivalents | (20) | (105) | (83) |
Net increase (decrease) in cash and equivalents | 670 | (714) | 1,632 |
Cash and equivalents, beginning of year | 3,138 | 3,852 | 2,220 |
CASH AND EQUIVALENTS, END OF YEAR | 3,808 | 3,138 | 3,852 |
Cash paid during the year for: | |||
Interest, net of capitalized interest | 98 | 70 | 53 |
Income taxes | 703 | 748 | 1,262 |
Non-cash additions to property, plant and equipment | 266 | 252 | 206 |
Dividends declared and not paid | $ 300 | $ 271 | $ 240 |