this is for myfinance lab , would really like some help
nekutter Speed Char ace e Home Insert Draw Page Layout Formulas Review View Hel Search Share Comments 2 A BTW- - - A- . General S -% 9 Mega Center - 8 MN June 290.00 July 425.00 S S August 500.00 $ September S 600.00 October S 625.00 November December S 650.00 $ 700.00 Cash Budget July through December 2020 May Sales Forecasts (000's) $ 300.00 Cash Sales 1296 $ 36.00 Less Discount S 9.00 Collections of A/R Larged one month 75% Lagged two months 13% Total Cash Receipts 60% 09 - SS 100% Purchases of Sales) Cash Purchases Payment of A/P Lagged one month Wages Lease Payments Advertising Expense R&D Expenditures Chapter 4 240 1296 10/11/2019 Times New Roman - 11 TOT A - Mega - pboards -% 9 Font .com Formatting Table Styles Format D Lease Payments Advertising Expense R&D Expenditures Prepaid Insurance Other Expenses Taxes Total Cash Disbursements 2% 39 12% S 15.00 $ S 30.00 $ 35.00 20.00 $ $ 20.00 S 25.00 40.00 65.00 $ $ $ $ 24.00 40.00 45.00 109.00 S 15.00 $ S 30.00 $ 35.00 S 15.00 - 20.00 S 30.00 S 35.00 $ 109.00 Cash Budget: Total Cash Receipts Less: Total Cash Disbursements New Cash Flow Add: Beginning Balance Ending Balance Less: Minimum Cash Balance Required Total Financing (notes payable) Excess Cash balance (marketable securities) S 15.00 $ 15.00 S 15.00 $ 15.00 15.00 S 15.00 $ 15.00 Chapter 4 $ 15.00 Add: Beginning Balance Ending Balance Less: Minimum Cash Balance Required Total Financing (notes payable) Excess Cash balance (marketable securities) $ 15.00 $ 15.00 $ 15.00 $ 15.00 $ 15.00 S b. Based on your analysis, briefly describe the outlook for this company over the next 6 months. Discuss its specific obligations and the finds available to meet them. What could the firm do in the case of a cash deficit? (Where could it get the money?) What should the firm do if it has a cash surplus? ACME Corporation will need notes payable financing in months ACME Corporation will invest in marketable securities in months Points 82 Requirements 1 In cell range F46:M46, by using cell references to the given data, calculate the cash sales for the months of May thru December. Note: Be sure to use absolute cell reference where necessary to assist with the copy/paste function. Chapter 4 Ready Tmes New Roman 14 A Paste Baler Merge Center - - A $.9 9 Conditional Formulas Cell Formatting Table Styles board * The expected purchases of raw materials in any given month are based on 6 of the expected sales during the following month G H CD Spreadsheet Exercise: Chapter 4 You have been assigned the task of putting together a statement for the ACME Company that shows its expected inflows and outflows of cash over the months of July 2020 through December 2020 You have been given the following data for ACME Company: 1 Expected gross sales for May through December, respectively, are $300,000, S290,000, $125,000, $500,000, $600,000, $625,000 $650,000, and $700,000. 2 12% of the sales in any given month are collected during that month. However, the firm has a credit policy of 3/10 net 30. so factor a 3% discount into the current month's sales collection. 3 75% of the sales in any given month are collected during the following month after the sale. 4 13% of the sales in any given month are collected during the second month following the sale. 5 The expected purchases of raw materials in any given month are based on 60% of the expected sales during the following month. 6 The firm pays 100% of its current month's raw materials purchases in the following month 7 Wages and salaries are paid on a monthly basis and are based on 6% of the current month's expected sales. 8 Monthly lease payments are 2% of the current month's expected sales. 9 The monthly advertising expense amounts to 3% of sales. 10 R&D expenditures are expected to be allocated to August September, and October at the rate of 12% of Chapter 4 11 During December a prepayment of insurance for the following year will be made in the amount of $24,000. 12 During the months of July through December, the firm expects to have miscellaneous expenditures of $15,000, $20,000, $25,000, $30,000, $35,000, and $40,000, respectively. 13 Taxes will be paid in September in the amount of $40,000 and in December in the amount of $45,000. 14 The beginning cash balance in July is $15,000. 15 The target cash balance is $15,000. 20 21 To Do Chapter 4 Ready