Indicate the maximum amount of bank borrowing that is needed

Assignment Help Finance Basics
Reference no: EM131123574

Artero Corporation is a traditional toy products retailer that recently 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 last three months of 2011 are forecasted to be:
SALES FORECAST

MONTH (IN $ THOUSANDS)

October 2011 ....... $1,000

November ........ 1,500

December ........ 3,000

Artero's balance sheet as of the end of September 2011 was as follows:

 

All sales are made on credit terms of net 30 days and are collected the following month. 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 averages 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 percent. 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 percent.

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

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

C. Prepare both a monthly cash budget and pro forma statements of cash flows for October, November, and December 2011.

D. Describe your findings and indicate the maximum amount of bank borrowing that is needed.

Reference no: EM131123574

Estimate the sustainable sales growth rate for the munich co

Munich has a target dividend payout of 40 percent of net income. Based on the 2010 financial statements relationships, estimate the sustainable sales growth rate for the Munic

What would be your estimate of the additional funds needed

A. What would be your estimate of the additional funds needed next year to support a 30 percent increase in sales? B. How would your answer in Part A change if the expected sa

Estimate the sustainable sales growth rate for petal provide

A. Estimate the sustainable sales growth rate for Petal Providers based on the information provided in this problem. B. How would your answer to Part A change if economic grow

Estimate the average sales growth rate for petal providers

Estimate the average sales growth rate for Petal Providers for next year. Estimate the dollar amount of sales expected next year under each scenario, as well as the expected v

Prepare a cash budget for august 2011 for pdc and describe

A. Prepare PDC’s sales schedule, purchases schedule, and wages schedule for August 2011. B. Prepare a cash budget for August 2011 for PDC and describe how the forecast affects

Describe how cash budgets and projected financial statements

From the Headlines—Chipotle: Describe how cash budgets and projected financial statements could be used in estimating how far $360 million could take Chipotle after its first

Prepare pdcs projected balance sheet for august

Prepare PDCs projected balance sheet for August. Prepare PDCs projected statement of cash flow for August. Compare your balance sheet at the end of August with the balance she

Compare and contrast scandi results with the industry averag

Compare and contrast Scandi's results with the industry average in terms of the ROA and ROE models. Make sure you compare the components of each model as well as the product o

Reviews

Write a Review

 
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd