Ask Financial Accounting Expert

a. Using the information provided, construct a monthly cash budget for October through December 2011. Based on your analysis, will Noble enjoy a surfeit of cash, or require external financing?

b. Construct a pro forma income statement for the first fiscal quarter of 2012 and a pro forma balance sheet as of December 31, 2011. What is your estimated external financing required for December 31?

c. Does the December 31, 2011, estimated external financing equal your cash surplus (deficit) for this date from your cash budget?

d. Based on your answers above, construct a cash flow forecast for Noble for the period October through December 2011.

Noble Selected Information and Financial Statements

Sales (20 percent for cash, the rest on 30-day credit terms):

2011 Actual   2011Projected

July August September October November December

76k 88k 266k 125k 51k 53k

Purchases (all on 60-day terms):

2011 Actual   2011 Projected

July August September October November December

116k 122k 257k 62k 27k 26k

Salaries payable monthly:20k

Principal payment on debt due in December:25,700

Interest due in December:9k

Dividend payable in December:15k

Taxes payable in November:19k

Addition to accumulated depreciation in December:4k

Cash balance on October 1, 2011:35k

Minimum desired cash balance: 15k

Noble’s annual income statement and balance sheet for September 30, 2011 appear below. Additional information about the company's accounting methods and expectations for the last three months of 2011 appear in the footnotes.

Noble Annual Income Statement

Fiscal Year ended September 30, 2011 ($ 000)

Net sales:1581.6

Cost of goods sold1:1098.0

Gross profits: 483.6

Selling and administrative expenses2:240.0

Interest expense:18.0

Depreciation3:16.0

Net profit before tax: 209.6

Tax at 33%:69.2

Net profit after tax:140.4

Noble Balance Sheet

September 30, 2011 ($000)

Assets

Cash: 34.0

Accounts receivable: 212.8

Inventory: 425.0

Total current assets:671.8

Gross fixed assets:135.0

Accumulated depreciation:52.0

Net fixed assets:83.0

Total assets:754.8

Liabilities

Bank Loan:0.0

Accounts Payable:379.0

Accrued Expenses:55.0

Current portion long-term debt5:25.7

Taxes payable:56.0

Total current liabilities:515.7

Long-term debt:120.0

Shareholders' equity:119.1

Total liabilities and equity:754.8

1- Cost of goods sold consists entirely of items purchased during the quarter.

2- Selling and administrative expenses consist entirely of salaries.

3-Depreciation is straight-line at the rate of $4,000 per quarter.

4-Accrued expenses are not expected to change in the last quarter.

5-$25.7 due Dec.

Financial Accounting, Accounting

  • Category:- Financial Accounting
  • Reference No.:- M91363311
  • Price:- $40

Guranteed 36 Hours Delivery, In Price:- $40

Have any Question?


Related Questions in Financial Accounting

Case study - the athletes storerequiredonce you have read

Case Study - The Athletes Store Required: Once you have read through the assignment complete the following tasks in order and produce the following reports Part 1 i. Enter the business information including name, address ...

Scenario assume that a manufacturing company usually pays a

Scenario: Assume that a manufacturing company usually pays a waste company (by the pound to haul away manufacturing waste. Recently, a landfill gas company offered to buy a small portion of the waste for cash, saving the ...

Lease classification considering firm guidance issues

Lease Classification, Considering Firm Guidance (Issues Memo) Facts: Tech Startup Inc. ("Lessee") is entering into a contract with Developer Inc. ("Landlord") to rent Landlord's newly constructed office building located ...

A review of the ledger of oriole company at december 31

A review of the ledger of Oriole Company at December 31, 2017, produces these data pertaining to the preparation of annual adjusting entries. 1. Prepaid Insurance $19,404. The company has separate insurance policies on i ...

Chelsea is expected to pay an annual dividend of 126 a

Chelsea is expected to pay an annual dividend of $1.26 a share next year. The market price of the stock is $24.09 and the growth 2.6 percent. What is the cost of equity?

Sweet treats common stock is currently priced at 3672 a

Sweet treats common stock is currently priced at $36.72 a share. The company just paid $2.18 per share as its annual dividend. The dividends have been increasing by 2,2 percent annually and are expected to continue doing ...

Highway express has paid annual dividends of 132 133 138

Highway Express has paid annual dividends of $1.32, $1.33, $1.38, $1.40, and $1.42 over the past five years, respectively. What is the average divided growth rate?

An investment offers 6800 per year with the first payment

An investment offers $6,800 per year, with the first payment occurring one year from now. The required return is 7 percent. a. What would the value be today if the payments occurred for 20 years?  b. What would the value ...

Oil services corp reports the following eps data in its

Oil Services Corp. reports the following EPS data in its 2017 annual report (in million except per share data). Net income $1,827 Earnings per share: Basic $1.56 Diluted $1.54 Weighted average shares outstanding: Basic 1 ...

At the start of 2013 shasta corporation has 15000

At the start of 2013, Shasta Corporation has 15,000 outstanding shares of preferred stock, each with a $60 par value and a cumulative 7% annual dividend. The company also has 28,000 shares of common stock outstanding wit ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As