The financial staff of the Romulians Co. has compiled the following set of assumptions and forecasts...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The financial staff of the Romulians Co. has compiled the following set of assumptions and forecasts to be used in the cash budgeting process: 1) Actual sales for November and December 2009 are given and expected sales for January to July are given. 2) 50% of sales are for cash. Of the remaining sales, 60% are collected in the following month and 40% are collected two months after the sale. 3) Actual purchases for November and December 2009 are given. Inventory purchases are equal to 50% of the following month's sales. 4) 50% of purchases are paid for in the month following the purchase, and the remainder are paid in the following month. 5) Annual borrowing rate is 7%. 6) Wages, taxes and other expenses are expected to be 40% of forecasted sales. 7) A major capital expenditure of $150,000 is expected in April. 8) Interest payments are expected to be 550,000 every month. 9) The beginning cash balance in January 2010 is $25,000, and the company needs a minimum cash balance of $20,000, Required: Help the financial staff of the Romulians Co., to prepare their cash budget for January to June 2010. Sales Collections: Cash First Month Second Month Total Collections Purchases Payments First Month Second Month Total Payments Collections Less Disbursements: Inventory Payments Wages, Tax and Other Exp Interest Payments Capital Spenditure Short-Term Interest Exp. Total Disbursements Beginning Cash Balance Collections Disbursement Unadjusted Cash Balance Current Borrowing Ending Cash Balance Cumulative Borrowing Notes: Minimum Acceptable Cash Borrowing Rate (Annual) Monthly 50% 30% 20% 50% 50% 50% 40% 20,000 7% ??? November 470,000 148,000 Romulians Co. Cash Budget For the Period January to June 2010 January February 436,500 547,500 December 282,000 111,000 25,000 3 ??? ??? ??? 327 ??? 727 ??? ??? 777 50,000 0 222 777 222 777 777 ??? 999 337 227 ??? 727 272 777 777 ??? 50,000 0 222 227 229 777 222 222 727 March 580,500 ??? ??? ??? 227 ??? 777 ??? 777 ??? 50,000 0 272 222 777 727 777 April 493,500 ??? ??? 222 222 222 772 227 222 ??? 277 ??? 50,000 150,000 222 777 229 ??? 227 222 777 May 357.000 ??? ??? ??? 727 ??? ??? 727 ??? 777 777 50,000 0 222 777 772 777 727 772 June 217,500 ??? 222 **F 222 227 777 777 222 ??? 227 ??? 50,000 0 227 777 229 ??? 277 222 ??? 138,000 The financial staff of the Romulians Co. has compiled the following set of assumptions and forecasts to be used in the cash budgeting process: 1) Actual sales for November and December 2009 are given and expected sales for January to July are given. 2) 50% of sales are for cash. Of the remaining sales, 60% are collected in the following month and 40% are collected two months after the sale. 3) Actual purchases for November and December 2009 are given. Inventory purchases are equal to 50% of the following month's sales. 4) 50% of purchases are paid for in the month following the purchase, and the remainder are paid in the following month. 5) Annual borrowing rate is 7%. 6) Wages, taxes and other expenses are expected to be 40% of forecasted sales. 7) A major capital expenditure of $150,000 is expected in April. 8) Interest payments are expected to be 550,000 every month. 9) The beginning cash balance in January 2010 is $25,000, and the company needs a minimum cash balance of $20,000, Required: Help the financial staff of the Romulians Co., to prepare their cash budget for January to June 2010. Sales Collections: Cash First Month Second Month Total Collections Purchases Payments First Month Second Month Total Payments Collections Less Disbursements: Inventory Payments Wages, Tax and Other Exp Interest Payments Capital Spenditure Short-Term Interest Exp. Total Disbursements Beginning Cash Balance Collections Disbursement Unadjusted Cash Balance Current Borrowing Ending Cash Balance Cumulative Borrowing Notes: Minimum Acceptable Cash Borrowing Rate (Annual) Monthly 50% 30% 20% 50% 50% 50% 40% 20,000 7% ??? November 470,000 148,000 Romulians Co. Cash Budget For the Period January to June 2010 January February 436,500 547,500 December 282,000 111,000 25,000 3 ??? ??? ??? 327 ??? 727 ??? ??? 777 50,000 0 222 777 222 777 777 ??? 999 337 227 ??? 727 272 777 777 ??? 50,000 0 222 227 229 777 222 222 727 March 580,500 ??? ??? ??? 227 ??? 777 ??? 777 ??? 50,000 0 272 222 777 727 777 April 493,500 ??? ??? 222 222 222 772 227 222 ??? 277 ??? 50,000 150,000 222 777 229 ??? 227 222 777 May 357.000 ??? ??? ??? 727 ??? ??? 727 ??? 777 777 50,000 0 222 777 772 777 727 772 June 217,500 ??? 222 **F 222 227 777 777 222 ??? 227 ??? 50,000 0 227 777 229 ??? 277 222 ??? 138,000
Expert Answer:
Answer rating: 100% (QA)
Sales Collections Cash First Month Second Month Total Collections Purchases Payments First Month Sec... View the full answer
Related Book For
Intermediate Financial Management
ISBN: 978-1285850030
12th edition
Authors: Eugene F. Brigham, Phillip R. Daves
Posted Date:
Students also viewed these accounting questions
-
The bore size on a component to be used in assembly is a critical dimension. Samples of size 4 are collected and the sample average diameter and range are calculated. After 25 samples, we have The...
-
Two different lathes turn shafts to be used in electric motors. Measurements made of their diameters (in cm) are Construct two stem-and- leaf diagrams to see if you should suspect that the two lathes...
-
A flow meter to be used in a 40 cm pipeline carrying oil (v = 10 5 m 2 /s, = 860 kg/m 3 ) is to be calibrated by means of a model (1/12 scale) carrying water (T = 20C and standard atmospheric...
-
The North American and European continents are moving apart at a rate of about 3 cm/y. At this rate how long will it take them to drift 500 km farther apart than they are at present?
-
What is the difference between the internal growth rate and the sustainable growth rate?
-
The production engineers at Impact Industries have derived the expansion path shown in the following figure. The price of labor is $100 per unit. a. What price does Impact Industries pay for capital?...
-
What does the term current liabilities mean?
-
Superheated steam at 575C is routed from a boiler to the turbine of an electric power plant through steel tubes (k = 35 W/m K) of 300 mm inner diameter and 30 mm wall thickness. To reduce heat loss...
-
Evaluate the current communications mix for an online e-tailer and make recommendations for future communications to achieve customer acquisition and retention
-
Describe a representation that could be used in a program to solve analogy problems like that in Figure 7.29. This class of problems was addressed by T. G. Evans (1968). The representation must be...
-
The "bell shaped" curve, formally known as the Normal Distribution , has wide application over a broad range of fields. Write down the probability distribution function for the Normal or as it is...
-
How do ethical dilemmas and moral decision-making processes influence organizational behavior, and what frameworks can leaders utilize to promote ethical conduct and integrity within their...
-
Barney Company is an 8 0 % owned subsidiary Hayes Inc. During 2 0 X 2 , Hayes sold land to Barney for $ 6 0 , 0 0 0 . Based upon an independent appraisal of the land s value. The land originally cost...
-
Compute free cash flow for this year. Current assets: Cash $ 3 6 , 0 0 0 $ 5 8 , 2 0 0 Accounts Receivable 2 4 9 , 4 0 0 2 3 7 , 3 0 0 Inventory 2 6 8 , 9 0 0 2 0 8 , 6 0 0 Prepaid expenses 2 1 , 7 0...
-
The long - term liabilities and stockholders' equity section of T . Ltd . at January 1 , 2 0 1 9 , was as follows: Long - Term Liabilities 8 % convertible bonds, each $ 1 , 0 0 0 bond convertible...
-
How do we establish clear expectations and metrics for accountability at both the individual and team levels, fostering a sense of responsibility and commitment to achieving goals ?
-
1. Draw R-S phase equilibrium diagram that best fits the following microstructures and label all fields in the diagram. Images show the phases during equilibrium cooling at a range of compositions....
-
Write a program to move a signed number from smaller register to bigger register. Hint: movzx ax, bl Topic: Data Related Operators and Directives in assembly language
-
a. It is January and Tennessee Sunshine is considering issuing $5 million in bonds in June to raise capital for an expansion, and is concerned that interest rates will rise during the interim....
-
a. Johnson plans to use the preceding ratios as the starting point for discussions with RR's operating team. She wants everyone to think about the pros and cons of changing each type of current asset...
-
Answer the following questions: a. Suppose Asset A has an expected return of 10% and a standard deviation of 20%. Asset B has an expected return of 16% and a standard deviation of 40%. If the...
-
The statement of financial position and income statement provide complementary, but contrasting information. Discuss.
-
Explain why bagging decision trees are a special case of random forests.
-
Show that (8.28) holds.
Study smarter with the SolutionInn App