Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

  1. 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

  1. 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.
  2. Calculate the Return on Equity (ROE) for the restaurant's and its Industry by using the Du Pont Identity and using values from 2020.
  3. 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.
  4. 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions