Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The actual 2022 balance sheet and partially completed 2023 projected financial statements for MBA, Inc. are shown below. Use this financial data along with the

The actual 2022 balance sheet and partially completed 2023 projected financial statements for MBA, Inc. are shown below. Use this financial data along with the assumptions below to complete the projected statements for 2023 by filling in the boxes. All the data are in $ millions.

Be careful. Each box is worth 1.4 points and there is no partial credit! Negative numbers (e.g., expenses on the income statement, etc.) must be shown in parentheses. DO NOT USE DOLLAR SIGNS OR DECIMAL POINTS. ROUND all calculations to the nearest million dollars!

Make the following assumptions when completing the financial statements:

  1. Sales were $5,000 million in 2022 and Expected sales growth for 2023 is 15%.
  2. Inventory turnover (Cost of Goods Sold/Average Inventory) was equal to 6.1 in 2022. The same inventory turnover is expected for 2023.
  3. PP&E acquisitions in 2023 will amount to $ 1800 and one acre of land is projected to be sold at cost.
  4. Interest Expense is expected to be 6% of the average of Short term debt (STD) and Long term debt (LTD) during the year.
  5. There will be no repayments of debt and no repurchase of common stock in 2023.
image

MBA, Inc. Projected Financial Statements for 2023 Balance Sheet (at year end) 2023 2022 Cash 45 Accounts Receivable 175 100 Inventory 500 PPE 6,975 5,325 Less: Accumulated depreciation (2,925) (1,700) Total Assets 5,000 4,270 Accounts payable 300 306 STD 786 714 LTD 2,000 Total Liabilities 3,586 3,020 Com Stock 450 RE 919 800 Total Stockholders' Equity 1,414 1,250 Total liabilities and TSE 5,000 4,270 Income Statement Net Sales Cost of Goods Sold Operating Expenses Interest expense Income Before Taxes Income tax expense Net Income 450 (135) 315 Statement of Cash Flows Net Income 315 Depreciation Expense Change in Accounts Receivable Change in Inventory (200) Change in Accounts Payable Cash Flow from Operations Acquisition of PPE Sale of PPE Cash flow from Investing NetSTD issued(repaid) NetLTD issued(repaid) Common Stock issued (repurch.) Dividends Cash Flow from Financing Increase (Decrease) in cash (1,650)

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_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

Financial Reporting Financial Statement Analysis And Valuation A Strategic Perspective

Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw

8th Edition

1285190904, 978-1305176348, 1305176340, 978-1285190907

More Books

Students also viewed these Finance questions