ezto.mheducation.com/ext/common/excelonline/ex Apps Gmail YouTube Maps New Tab Login | Salesforce W Morning O Search (Alt + Q) Excel McGraw Hill Excel Question - Saved He Review View File Data Home Insert Draw Formulas Calibri 11 29 Wrap Text E Merge & Center Paste BI U e sota Av Font Alignment Undo Clipboard B30 fx G 1 2 Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash 3 payments for loan principal and interest payments) for the first three months of next year 4 5 Cash Receipts Cash payments 6 January $525,000 $475,000 7 February 400,000 350,000 8 March 450,000 525,000 9 10 Kayak requires a minimum cash balance of $30,000 at each month-end Loans taken to Minimum Cash Monthly January 1 Cash 11 meet this requirement charge 1% interest per month, paid at each month-end The Balance interest rate balance 12 interest is computed based on the beginning balance of the loan for the month Any $30,000 1% $30,000 13 preliminary cash balance above $30,000 is used to repayloans at month-end. The company has a cash balance of $30,000 and a loan balance of $60,000 at January 1. 15 16 Required: 17 Prepare monthly cash budgets for January, February, and March 18 19 (Use cells As to 134 from the given Information to complete this question. Negative balances and Loan repayment amounts (if any) 20 should be indicated with minus sien. Negative amounts or amounts to be deducted should be input and displayed as negative values. All 21 other answers should be input and displayed as positive values.) 22 January 1 loan balance $60,000 A Graded Worksheet + Search (Alt Excel McGraw Hill Excel Question - Saved View Formulas Data Review File Home Draw Insert ID Calibri 11 A A BI U B to B v Av 25 Wrap Text Merge & ce Paste C H Alignment Font Undo Clipboard B30 fx G D 8 Should be indicated with minus en negative amounts or amounts to be deacted should be input and played as negave van. A 21 other answers should be input and displayed as positive values.) 22 23 KAYAK COMPANY 24 Cash Budget March 25 February January $30,000 26 Beginning cash balance $30,000 $30,000 27 Add: Cash receipts 525,000 400,000 450,000 28 Total cash available 555,000 430,000 480,000 29 Less Cash payments for 30 All items excluding interest 31 Interest on loan 32 Total cash payments 33 Preliminary cash balance 34 Loan activity 35 36 Endine cash balance 37 Loan balance 38 Loan balance - Beginning of month 39 Additional loan (loan repayment) 40 Loan balance, end of month 41 + = Graded Worksheet Calculation Mode: Automatic Workbook Statistics