Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Balance Sheet as of December 31, 2021 (In Millions) Cash 0.15 Accounts payable 0.17 Accounts receivable 0.47 Capital Lease Liability* 0.14 Inventories 0.55 Total Liabilities

Balance Sheet as of

December 31, 2021 (In Millions)

Cash

0.15

Accounts payable

0.17

Accounts receivable

0.47

Capital Lease Liability*

0.14

Inventories

0.55

Total Liabilities

0.31

Net fixed assets*

0.14

Equity

1.00

Total assets

$1.31

Total Liabilities and Equity

$1.31

sales over each quarter of 2022 are forecasted to be:

Sales Forecast

(In Millions)

Q1

$ 0.50

Q2

$ 0.75

Q3

$ 0.85

Q4

$ 0.90

Total

$ 3.00

All sales are made on credit terms of net 90 days and are collected the following quarter. No bad debts are anticipated. The accounts receivable on the balance sheet at the end of 2021 thus will be collected in Quarter 1, 2022. Quarter 1, 2022 sales will be collected in Quarter 2, and so on.

Inventory on hand represents a minimum operating level (safety stock), which the company intends to maintain. ALMA.coms policy is to maintain ending inventory at the end of each quarter equals to 30% of next quarter's expected sales. Purchases are paid 60% in the same quarter and 40% in the next quarter. Cost of goods sold averages 70% of sales (gross profit margin 30%).

General, Administration and Selling cash expenses average 10% of sales. Depreciation is $0.01M per Quarter. The annual interest rate on outstanding lease liability is 5%. Interest expense is paid quarterly. Ms Alma Serah assumes taxes are paid quarterly and the income tax rate is 40% for budgeting purposes. The capital lease installment is 0.08M per Year (0.02 per quarter). There are no additional capital expenditures planned during 2022, and no equity payouts will be paid. The companys desired end-of- quarter minimum cash balance is $0.15M. Ms Serah hopes to meet any cash shortages during the period by an agreed $0.15M open line of credit with the bank at 4%.

1. Prepare quarterly cash budget for Q1, Q2, Q3, and for Q4 ending December 31, 2022.

2. Prepare the pro forma income statement for the year ending December 31, 2022.

3. Prepare the end of the year 2022 pro forma balance sheet.

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

Recommended Textbook for

The Lakeside Company Case Studies In Auditing

Authors: John Trussel, J. Douglas Frazer

12th Edition

0132567253, 978-0132567251

More Books

Students also viewed these Accounting questions

Question

Hello I need assignment help. Can I find a tutor to help me out

Answered: 1 week ago

Question

b. Explain how you initially felt about the communication.

Answered: 1 week ago