Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Jolene's Trucking Company prepared monthly cash budgets. Relevant data from operating budgets for 2021 are as follows: Time left 0:33:33 Required: Expected cash balance on
Jolene's Trucking Company prepared monthly cash budgets. Relevant data from operating budgets for 2021 are as follows: Time left 0:33:33 Required: Expected cash balance on March 1 $ 50,000 Ap February $ 200,000 $ March 350,000 $ Credit Sales (all sales are on account) 45 Month of 50% Collection pattern from customers credit sales Month after 50% $ Description Cash payments for expenses Equipment purchase (in cash) Collection of notes receivable Proceeds from sale of land $ $ $ March 300,000 $ 50,000 $ 25,000 $ $ April 375,000 50,000 30,000 20,000 Minimum cash balance at the end of each month $ 70,000 Any borrowings and repayments are done in increments of $1000. Interest can be ignored. Part A. Prepare a schedule of expected cash collections from customers for March and April (8 marks) (DO NOT ENTER ANY Dollar signs "$" or commas "," PLEASE ENTER NUMBERS AS 123456 and where 2 decimals indicated enter number like 123456.78) Jolene's Trucking Company Schedule of Expected Cash Collections For the two months ended April 30 ICCI Any borrowings and repayments are done in increments of $1000. Interest can be ignored. Part A. Prepare a schedule of expected cash collections from customers for March and April (8 mar (DO NOT ENTER ANY Dollar signs "$" or commas "." PLEASE ENTER NUMBERS AS 123456 and where 2 decimals indicated enter number like 123456.78) Jolene's Trucking Company Schedule of Expected Cash Collections For the two months ended April 30 March April February S March $ April S SS Cash collected from customers (use in cash budget in PART B) $ S (DO NOT ENTER ANY Dollar signs "s" or commas "," PLEASE ENTER NUMBERS AS 123456 and where 2 decimals indicated enter number like 123456.78) Required: Cash Budget PART B: Using the question data and your response to part a, prepare a cash budget for March and April using colum for each month. Also include a summary column for the two-month period, March 1st - April 30th. (20 mark Jolene's Trucking Company Cash Budget Required: Cash Budget PART B: Time left 0:32:22 Using the question data and your response to part a, prepare a cash budget for March and April for each month. Also include a summary column for the two-month period, March 1st - April 30th. (20 marks) Jolene's Trucking Company Cash Budget For the two months ended April 30 March April Summary March 1st to April 30th $ Cash balance, beginning $50000 $ Cash collections: (Must be listed alphabetically) $ $ Choose $ $ Choose.. $ $ II. Choose $ $ Total available cash March Continued April Continued Summary March 1st to April 30th $ Excess (deficiency) Financing Borrowings S $ 159 Repayments: (show as negative) $ S $ Total Financing SI $ Cash balance, ending S SI $ Total Financing Cash balance, ending BONUS QUESTIONS: (1 mark each) What is the accounts receivable balance as at April 30th? How much of the loan is outstanding at April 30th? $ Jolene's Trucking Company prepared monthly cash budgets. Relevant data from operating budgets for 2021 are as follows: Time left 0:33:33 Required: Expected cash balance on March 1 $ 50,000 Ap February $ 200,000 $ March 350,000 $ Credit Sales (all sales are on account) 45 Month of 50% Collection pattern from customers credit sales Month after 50% $ Description Cash payments for expenses Equipment purchase (in cash) Collection of notes receivable Proceeds from sale of land $ $ $ March 300,000 $ 50,000 $ 25,000 $ $ April 375,000 50,000 30,000 20,000 Minimum cash balance at the end of each month $ 70,000 Any borrowings and repayments are done in increments of $1000. Interest can be ignored. Part A. Prepare a schedule of expected cash collections from customers for March and April (8 marks) (DO NOT ENTER ANY Dollar signs "$" or commas "," PLEASE ENTER NUMBERS AS 123456 and where 2 decimals indicated enter number like 123456.78) Jolene's Trucking Company Schedule of Expected Cash Collections For the two months ended April 30 ICCI Any borrowings and repayments are done in increments of $1000. Interest can be ignored. Part A. Prepare a schedule of expected cash collections from customers for March and April (8 mar (DO NOT ENTER ANY Dollar signs "$" or commas "." PLEASE ENTER NUMBERS AS 123456 and where 2 decimals indicated enter number like 123456.78) Jolene's Trucking Company Schedule of Expected Cash Collections For the two months ended April 30 March April February S March $ April S SS Cash collected from customers (use in cash budget in PART B) $ S (DO NOT ENTER ANY Dollar signs "s" or commas "," PLEASE ENTER NUMBERS AS 123456 and where 2 decimals indicated enter number like 123456.78) Required: Cash Budget PART B: Using the question data and your response to part a, prepare a cash budget for March and April using colum for each month. Also include a summary column for the two-month period, March 1st - April 30th. (20 mark Jolene's Trucking Company Cash Budget Required: Cash Budget PART B: Time left 0:32:22 Using the question data and your response to part a, prepare a cash budget for March and April for each month. Also include a summary column for the two-month period, March 1st - April 30th. (20 marks) Jolene's Trucking Company Cash Budget For the two months ended April 30 March April Summary March 1st to April 30th $ Cash balance, beginning $50000 $ Cash collections: (Must be listed alphabetically) $ $ Choose $ $ Choose.. $ $ II. Choose $ $ Total available cash March Continued April Continued Summary March 1st to April 30th $ Excess (deficiency) Financing Borrowings S $ 159 Repayments: (show as negative) $ S $ Total Financing SI $ Cash balance, ending S SI $ Total Financing Cash balance, ending BONUS QUESTIONS: (1 mark each) What is the accounts receivable balance as at April 30th? How much of the loan is outstanding at April 30th? $
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