Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Complete the Combined Cash Budget for the fourth quarter (Oct, Nov, Dec), using the table below for Dock Corp. Any financing is done in $1000
Complete the Combined Cash Budget for the fourth quarter (Oct, Nov, Dec), using the table below for Dock Corp. Any financing is done in $1000 increments, and interest is charged at 1% per month. Loans are taken out and repaid only at the end of the month, depending upon cash availability. Dock Corp requires a minimum $50,000 cash balance at the end of each month. Prepare your answer by indicating the "dollar amount" for each cell labelled from A to Z. Your answer will list (in alpha order) the letters A, B, C etc to letter Z, with the line name or amount corresponding to each letter in the table. Some letters do not require a dollar amount answer. Cash payments are budgeted to be: $150,000 in October; $80,000 in November and $75,000 in December. The bank balance on October 1 is $55,000. Cash collections in the fourth quarter are as follows: October $110,000; November $65,000; December $140,000. OCTOBER NOVEMBER DECEMBER Beginning cash balance A R Cash Collections B S Total cash available C K T Cash Payments D U End cash, before financing m M FINANCING Borrowings F N W repayments G O X Interest (1% per month) P Y End Cash Balance H Q Z
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started