Using the information provided, construct a monthly cash budget for October through December 2014. Based on...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Using the information provided, construct a monthly cash budget for October through December 2014. Based on your analysis, will Noble enjoy a surfeit of cash, or require external financing? Construct a pro forma income statement for the first fiscal quarter of 2015 and a pro forma balance sheet as of December 31, 2014. What is a b your estimated external financing needed for December 31? Does the December 31, 2014, 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 2014. Noble Selected Information and Financial Statements Sales (20 percent for cash, the rest on 30-day credit terms): 2014 Actual 2014 Projected October July 76,000 August September November December 88,000 266,000 125,000 51,000 53,000 Purchases (all on 60-day terms): 2014 Actual 2014 Projected July August September October November December 116,000 122,000 257,000 62,000 27,000 26,000 Salaries payable monthly Principal payment on debt due in December Interest due in December 20,000 25,700 9,000 Dividend payable in December Taxes payable in November Addition to accumulated depreciation in December 15,000 19,000 4,000 Cash balance on October 1, 2014 34,000 Minimum desired cash balance 15,000 Noble's annual income statement and balance sheet for September 30, 2014 appear below. Additional information about the company's accounting methods and expectations for the last three months of 2014 appear in the footnotes. Noble Annual Income Statement Fiscal Year ended September 30, 2014 ($ 000) Net sales 1,581.6 Cost of goods sold' Gross profits 1,098.0 483.6 Selling and administrative expenses? Interest expense 240.0 18.0 Depreciation Net profit before tax 3 16.0 209.6 Tax at 33% 69.2 Net profit after tax 140.4 Noble Balance Sheet September 30, 2014 ($ 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 debt Taxes payable 25.7 56.0 Total current liabilities 515.7 Long-term debt Shareholders' equity 120.0 119.1 Total liabilities and equity 754.8 '. Cost of goods sold consists entirely of items purchased during the quarter. Selling and administrative expenses consist entirely of salaries. 3 . Depreciation is straight-line at the rate of $4,000 per quarter. Accrued expenses are not expected to change in the last quarter. $25.7 due December 2014. No payments for remainder of year. Using the information provided, construct a monthly cash budget for October through December 2014. Based on your analysis, will Noble enjoy a surfeit of cash, or require external financing? Construct a pro forma income statement for the first fiscal quarter of 2015 and a pro forma balance sheet as of December 31, 2014. What is a b your estimated external financing needed for December 31? Does the December 31, 2014, 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 2014. Noble Selected Information and Financial Statements Sales (20 percent for cash, the rest on 30-day credit terms): 2014 Actual 2014 Projected October July 76,000 August September November December 88,000 266,000 125,000 51,000 53,000 Purchases (all on 60-day terms): 2014 Actual 2014 Projected July August September October November December 116,000 122,000 257,000 62,000 27,000 26,000 Salaries payable monthly Principal payment on debt due in December Interest due in December 20,000 25,700 9,000 Dividend payable in December Taxes payable in November Addition to accumulated depreciation in December 15,000 19,000 4,000 Cash balance on October 1, 2014 34,000 Minimum desired cash balance 15,000 Noble's annual income statement and balance sheet for September 30, 2014 appear below. Additional information about the company's accounting methods and expectations for the last three months of 2014 appear in the footnotes. Noble Annual Income Statement Fiscal Year ended September 30, 2014 ($ 000) Net sales 1,581.6 Cost of goods sold' Gross profits 1,098.0 483.6 Selling and administrative expenses? Interest expense 240.0 18.0 Depreciation Net profit before tax 3 16.0 209.6 Tax at 33% 69.2 Net profit after tax 140.4 Noble Balance Sheet September 30, 2014 ($ 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 debt Taxes payable 25.7 56.0 Total current liabilities 515.7 Long-term debt Shareholders' equity 120.0 119.1 Total liabilities and equity 754.8 '. Cost of goods sold consists entirely of items purchased during the quarter. Selling and administrative expenses consist entirely of salaries. 3 . Depreciation is straight-line at the rate of $4,000 per quarter. Accrued expenses are not expected to change in the last quarter. $25.7 due December 2014. No payments for remainder of year.
Expert Answer:
Answer rating: 100% (QA)
SH Equity Sep Retained Earning in Quarter SH Equity De... View the full answer
Related Book For
Strategic Management and Competitive Advantage Concepts and Cases
ISBN: 978-0133127409
5th edition
Authors: Jay B. Barney, William Hesterly
Posted Date:
Students also viewed these accounting questions
-
Your assistant has prepared the following pro forma income statement for 2010. He used your forecast sales figure as the starting point. The administrative expenses are fixed except for salaries,...
-
Using the information provided in Exercise 2. Calculate Majikstan Enterprises net monetary gain or loss in local currency for 2011 based on the following general price-level information. 12/31/10...
-
Using the information provided in Problem 9, discuss all transaction listings and summary reports that would be necessary for a batch system with real-time input of data.
-
If you place a charged object next to an uncharged object thatis a conductor, If you place a charged object next to an uncharged object thatis a conductor, A) The force depends on whether the charge...
-
On January 1, 2014, Gato Company issued 1,000 shares of $ 80 par callable pre-ferred shares for $ 200,000. Callablepreferredshares for $200,000. Gato can call these preferred shares on January 1,...
-
Fit Gym began January with merchandise inventory of 78 crates of vitamins that cost a total of $4,290. During the month, Fit Gym purchased and sold merchandise on account as follows: Requirements 1....
-
Define entrepreneurial succession and differentiate between entrepreneurial succession in family and non-family firms.
-
Kopke Company, organized in 2012, has these transactions related to intangible assets in that year: Jan. 2 Purchased a patent (5-year life) $280,000. Apr. 1 Goodwill acquired as a result of purchased...
-
Blossom Company has accounts receivable of $92,000 at March 31, 2025. Credit terms are 2/10, n/30. At March 31, 2025, there is a $2,200 credit balance in Allowance for Doubtful Accounts prior to...
-
The trial balance of Rosiak Fashion Center contained the following accounts at November 30, the end of the companys fiscal year. Adjustment data: 1. Supplies on hand totaled 2,100. 2. Depreciation is...
-
Discuss the role of metafiction in shaping a reader's perception of the authorial process. How does this literary device blur the boundaries between fiction and reality?
-
Suppose that you have a sample of material B in the shape of a cylinder of length 12 cm and diameter 1.5 cm. The Young's modulus of material B is 85 GPa. In order to stretch the sample by 0.25 mm...
-
I A particle of unit mass (i.e. m = 1) moves in one dimension under the influence of a force F. Denoting its displacement by x and velocity by vc, find the most general form for x(t) for the case...
-
Joe, aged 24, and Kate, aged 24, met in college. While studying, Joe worked part-time selling car parts to autobody shops in the GTA. He earned $12,000 a year, for two years. After graduating from...
-
The trial balance below was extracted from Ssalongo and Sons Hardware Enterprises for the year ended 31 December, 2021. Account title: Debit Credit Shs '000' Shs '000' Capital 287,000 Inventory as at...
-
Think about the benefits of each type of federal student loan and then discuss how you feel about taking out student loans to pay for college. Consider the options that you have for funding your...
-
Mark can type 45 words per minute, how many words can make Mark type in 30 minutes?
-
Sheldon and Leonard had a million-dollar idea. In order to make it happen, they have to do special research first. Only Kripke can help them in this matter. But Kripke is known to be the first-class...
-
How is buying a car like and unlike vertical integration decisions?
-
Describe when the evolution of industry structure from an emerging industry to a mature industry to a declining industry is inevitable.
-
The learning curve depicted in Figure can be represented algebraically in the following equation: Average time to produce x units = ax-, where x is the total number of units produced by a firm in its...
-
Describe the steps in management decision making. What are the difficulties in making management decisions?
-
What are the four functions of management? How are they related to the work process?
-
Discuss the three general roles of management. What are the purposes of these roles? What specific roles fall under each general role?
Study smarter with the SolutionInn App