2 0 0 AutoSave @ Off ACT325Module04Student-TemplatexIsx - Excel LO Stephanie D X File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments Calibri 12 VA A ab Wrap Text General AY Paste BIU A Merge & Center $ % " Conditional Format as Cell Insert Delete Format Sort & Find & Ideas Formatting Table ~ Styles v Filter ~ Select Clipboard Font Alignment F Number Styles Cells Editing Ideas G55 X fax A B C D E F G H M N 18 19 20 1. Prepare monthly cash budgets for January, February, and March. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign.) 21 22 Cash Budget 23 January February March 24 Beginning Balance 50,000 | $ 69,000 $ 169,000 25 Cash Reciepts 550,000 $ 425,000 $ 475,000 26 Total Cash Available 600,000 $ 494,000 $ 644,000 27 Cash payments 430,000 $ 325,000 550,000 28 Interest expense $1,000 $ 29 3 Prelimnary cash balance 169,000 $ 169,000 $ 94,000 30 Additional loan/ loan repayment $100,000 $ 31 Ending Cash Balance $ 69,000 $ 169,000 S 94,000 32 33 Loan Balance at the beginning of month S 100,000 $ 34 Additional loan/ loan repayment $101,000 $ 35 Loan Balance-End of Month S S 36 37 Option 1 Option 2 + Ready 85% 4:52 PM D W 10/3/20202 0 0 AutoSave @ Off ACT325Module04Student-TemplatexIsx - Excel LO Stephanie D X File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments Calibri 12 VAA ab Wrap Text Custom AY Paste BIU A Merge & Center $ % 9 .0 Conditional Format as Cell Insert Delete Format Sort & Find & Ideas Formatting Table ~ Styles v Filter ~ Select Clipboard Font Alignment F Number Styles Cells Editing Ideas E58 X =D60 D E 0 Q If the cash receipts and cash payments were as follows, how would the cash budget change. 1. Prepare monthly cash budgets for January, February, and March. (Negative balances and Loan repayment amounts (if any) should be indicated in parentheses "(]".} 39 40 41 Cash Receipts Cash Payments 42 January 350,000 $ 430,000 43 February 400,000 325,000 44 March 575,000 5 400,000 45 46 47 Cash Budget 48 January February March 49 Beginning Balance S 60,000 5 19,000 5 50,000 Cash Receipts 350,000 5 400,000 |$ 575,000 Total Cash Available 400,000 $ 419,000 5 625,000 52 Cash payments 430,000 $ 325,000 |$ 400,000 Interest expense (1,000.00) $1,500 $1,075 Prelimnary cash balance 31,000.00) $ 92,500 $ 223,925 Additional loan/ loan repayment S 60,000 Ending Cash Balance Is $42,500) ($107,500) 19,000 $ 50,000 $ 116,425 58 Loan Balance at the beginning of month 100,000 | $ 150,000 $ 107,500 59 Additional loan/ loan repayment 49,000 544,000) ($108,575) 60 Loan Balance-End of Month 150,000 5 107,500 5 61 Option 1 Option 2 + 1 Ready LO + 70% 4:56 PM D W 10/3/20202 0 0 AutoSave @ Off ACT325Module04Student-TemplatexIsx - Excel LO Stephanie D X File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments Calibri 12 VA A ab Wrap Text General AY Paste BIU A Merge & Center $ % " Conditional Format as Cell Insert Delete Format Sort & Find & Ideas Formatting Table ~ Styles v Filter ~ Select Clipboard Font Alignment F Number Styles Cells Editing Ideas G55 X fc A B C D E F G H M N 1 Marble Company Contribution Margin Income Statement For Year Ending December 31, 2019 Option 1 According to a credit agreement with the company's bank, Marble Company promises to have a minimum cash balance of $50,000 at each month-end. In return, the bank has agreed that the company can borrow up to $150,000 at a monthly interest rate of 1%, paid on the last day of each month. The interest is computed based on the beginning balance of the loan for the month. The company repays loan principal with any cash in excess of $50,000 on the last day of each month. The company has a 8 cash balance of $50,000 and a loan balance of $100,000 at January 1. Marble Co. budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next 10 year. 11 12 Cash Receipts Cash Payments 13 January 550,000 S 430,000 14 February 425,000 $ 325,000 15 March 475,000 $ 550,000 Option 1 Option 2 + Ready 85% 4:52 PM D X W 10/3/2020