Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Artero Corporation is a traditional toy products retailer that recently also started an Internet- based subsidiary that sells toys online. A markup is added on

Artero Corporation is a traditional toy products retailer that recently also started an Internet- based subsidiary that sells toys online. A markup is added on goods the company purchases from manufacturers for resale. Swen Artero, the company president, is preparing for a meeting with Jennifer Brown, a loan officer with First Banco Corporation, to review year end financing requirements. After discussions with the companys marketing manager, Rolf Eriksson, and finance manager, Lisa Erdinger, sales over the last three months of 2020 are forecasted to be:

Month Sales Forecast

Ocrober 2020 $ 1000

November $ 1500

December $ 3000

Arteros balance sheet as of the end of September, 2020 was as follows.

Balance Sheet as of September 30 , 2020

Cash $50 Accounts payable $0

Accounts receivable 700 Notes payable 800

Inventories 500 long term debt 400

Net fixed assets 750 total liabilities 1200

Equity 800

Total assets 2000 total 2000

All sales are made on credit terms of net 30 days and are collected the following month and no bad debts are anticipated. The accounts receivable on the balance sheet at the end of September thus will be collected in October. The October sales will be collected in November, and so on. Inventory on hand represents a minimum operating level (or safety stock), which the company intends to maintain. Cost of goods sold average 80 percent of sales. Inventory is purchased in the month of sale and paid for in cash. Other cash expenses average 7 percent of sales. Depreciation is $10,000 per month. Assume taxes are paid monthly and the effective income tax rate is 40 percent for planning purposes.

The annual interest rate on outstanding long-term debt and bank loans (notes payable) is 12%. There are no capital expenditures planned during the period, and no dividends will be paid. The companys desired end-of-month cash balance is $80,000. The president hopes to meet any cash shortages during the period by increasing the firms notes payable to the bank. The interest rate on new loans will be 12 perce

Prepare monthly pro forma balance sheets at the end of October, November, and December, 2020.

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

Enterprise Applications And Services In The Finance Industry

Authors: Artur Lugmayr

1st Edition

331928150X,3319281518

More Books

Students also viewed these Finance questions

Question

What strategy options arise from these opportunities?

Answered: 1 week ago