### What is the maximum amount of bank borrowing that would

Assignment Help Finance Basics
##### Reference no: EM131123607

Artero Corporation, discussed in Problem 9, is a retailer of toy products. The firm's management team recently extended the monthly sales forecasts that were prepared for the last three months of 2011 for an additional six months in 2012. These forecasts were presented to Swen Artero, the firm's president, as follows:

MONTH SALES FORECASTS (\$)
October 2011 .. 1,000,000
November .... 1,500,000
December .... 3,000,000
January 2012 .. 1,500,000
February ..... 1,000,000
March ...... 700,000
April ...... 700,000
May ........ 700,000
June ....... 700,000

A. Use the income statement data and the balance sheet information from Problem 9 to prepare monthly income statements, balance sheets, and statements of cash flows for October through December 2011. What is the maximum amount of bank borrowing that would be needed?

B. Prepare monthly income statements, balance sheets, and statements of cash flows for the first six months of 2012. Assume the information and data relationships from Problem 9 will continue to hold for the first six months of 2012. Indicate if, and when, the additional bank borrowing needed during the last three months of 2011 can be repaid.

C. Based on your financial statement projections for the first six months of 2012, indicate whether new bank borrowing will be needed.

#### Prepare pdcs sales schedule purchases schedule

A. Prepare PDC’s sales schedule, purchases schedule, and wages schedule for each of the last four months of 2011. B. Prepare cash budgets for each of the last four months of 2

#### Indicate the maximum amount of bank borrowing that is needed

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

#### 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

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