Question
Mr. Parker has just been hired as a financial manager in a restaurant. His first responsibility is to examine the balance sheet and income statement
- Mr. Parker has just been hired as a financial manager in a restaurant. His first responsibility is to examine the balance sheet and income statement of the company for 2020 and decide on the financial health of the restaurant. However due to technical mistake, the data comes in a non-formatted form with some missing information as presented below (the values are in thousands).
Accounts payable | 6,700 |
Accounts receivable | 6,900 |
Accrued wages and taxes | 1,100 |
Cash and marketable securities | 4,000 |
Common stock and paid-in | 15,500 |
Cost of goods sold | 53,200 |
Depreciation expense | 500 |
Dividends paid | 560 |
Interest expense | 1,000 |
Inventory |
|
Long-term debt |
|
Net plant and equipment | 21,100 |
Net sales | 65,400 |
Notes payable | 4,900 |
Operating Expenses | 8,700 |
Other long-term assets | 11,000 |
Retained earnings |
|
Tax expense | 600 |
Mr. Parker realized that in order to calculate some of the missing information in the financial statements of the company, he needs additional data. He has also downloaded some financial ratios of the company.
| 2020 | Industry Average 2020 |
Current ratio | 1.5118 | 1.9 times |
Quick ratio |
| 1.1 times |
Inventory turnover ratio | 6.4096 | 8.0 times |
Total asset turnover ratio |
| 1.4 times |
Total debt ratio | 0.6374 | 0.6 times |
Times interest earned |
| 6.6 times |
Profit margin |
| 2.30% |
ROA |
| 3.20% |
EPS | 1.3000 |
|
- By using the information provided prepare formatted balance sheet, income statement and calculate the missing values in the financial statements of the company and missing financial ratios. Please round the numbers in the Balance Sheet and Income Statement to the nearest hundred dollars. For example, if you calculate a number to be $1,024 after rounding, this number is going to be $1,000.
- Calculate the Return on Equity (ROE) for the restaurant's and its Industry by using the Du Pont Identity and using values from 2020.
- Calculate the rate of growth for the restaurant's in a year using numbers from 2020 if it uses the retained earnings and debt as a source of financing this growth while keeping a constant debt ratio.
- Calculate the rate of growth for the restaurant's in a year if it uses only the retained earnings as a source of financing and changes its dividend payout ratio to 60%. (Please note that the new dividend payout ratio will change some of the numbers in the balance sheet of the company. Both left- and right-hand side of the balance sheet will change by the same amount.)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started