Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A) Prepare monthly pro forma income statements for October, November, and December, and for the quarter ending December 31, 2014. B) Prepare monthly pro forma

image text in transcribed

A) Prepare monthly pro forma income statements for October, November, and December, and for the quarter ending December 31, 2014.

B) Prepare monthly pro forma balance sheets at the end of October, November, and December, 2014

C) Prepare both a monthly cash budget and pro forma statements of cash flows for the October, November, and December 2014

(Please answer these questions in detail) and explain how to get the (interest payment) and (additional funds needed) please provide step by step for this particular part.

7. [Short-Term Financial Planning] 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 company's marketing manager Rolf Eriksson and finance manager Lisa Erdinger, sales over the next three months were forecasted as follows. Chapter 6: Managing Cash Flow 99 Artero's balance sheet as of the end of September, 2014 was as follows. Artero Corporation 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 company's desired end-of-month cash balance is $80,000. The president hopes to meet any cash shortages during the period by increasing the firm's notes payable to the bank. The interest rate on new loans will be 12%. 7. [Short-Term Financial Planning] 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 company's marketing manager Rolf Eriksson and finance manager Lisa Erdinger, sales over the next three months were forecasted as follows. Chapter 6: Managing Cash Flow 99 Artero's balance sheet as of the end of September, 2014 was as follows. Artero Corporation 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 company's desired end-of-month cash balance is $80,000. The president hopes to meet any cash shortages during the period by increasing the firm's notes payable to the bank. The interest rate on new loans will be 12%

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

More Books

Students also viewed these Finance questions