Answered step by step
Verified Expert Solution
Question
1 Approved Answer
solve step by step and coreectly plz solve every part of this question i send the whole question in brief please read it carefully and
solve step by step and coreectly
plz solve every part of this question
i send the whole question in brief please read it carefully and solve this question ASAP
Bet iakyotas' in have Question 5 - Cash Budget (30 marks) Mountain Sports has aquired an open line of credit up to a maximum of $350,000. It will be necessary to convince the bank manager of this new Canmore branch ability to repay its line of credit including any interest. Management has provided the following list of assumptions to help in the preparation of the cash budget (note: you will need to use the projected income statement provided in Question 4 to complete the cash budget): 1. Beginning cash balance invested by owners \begin{tabular}{|l|l|l|l|r|} \hline 2. Sales by quarter (as \% of total projected sales) & Quarter 1 & Quarter 2 & Quarter 3 & Quarter 4 \\ \hline \end{tabular} 3. Type of collections from customers: \begin{tabular}{|l|l|} \hline Cash Sales & 37% \\ \hline Credit Sales (accounts receivable) & 63% \\ \hline \end{tabular} Cash sales are collected in the quarter of the sale, all credit sales are collected in the quarter after the sale. 4. Merchandise purchases Merchandise purchases (cost of goods sold) are all paid in the quarter following purchase. (Quarter 1 purchases are bought in Quarter 1 but paid for in quarter 2). 5. Operating expenses All other operating expenses (all expenses except cost of goods sold) are paid on a monthly basis. 6. Required investment in equipment paid in cash in the first quarter 7. Quarterly income tax payments paid in cash 133,000 8. Minimum cash balance 9. Borrowing and Repayments: Any borrowing will take place on the first day of the quarter and any repayments are paid at the end of the quarter. All borrowing and payments are made in increments of $1,000. Interest on borrowing can be ignored. Required: Prepare a cash budget for the first year of operation in Canmore by quarter and in total. Show clearly on your budget the quarter(s) in which borrowing will be needed and the quarter(s) in which repayments can be made, as requested by the company's bank. Question 5 - Cash Budget (30 marks) Mountain Sports has acquired an open line of credit up to a maximum of $350,000. It will be necessary to convince the bank manager of this new Canmore branch ability to repay its line of credit including any interest. Refer to the excel file for the following required tasks: - Part 5A: Chapter 10 (30 marks) Prepare a cash budget for the first year of operation in Canmore by quarter and in total. Show clearly on your budget the quarter(s) in which borrowing will be needed and the quarter(s) in which repayments can be made, as requested by the company's bank. Question 5 Check Figures 32 Be rerspues's buek. Question 5 - Cash Budget (30 marks) Mountain Sports has aquired an open line of credit up to a maximum of $350,000. It will be necessary to convince the bank manager of this new Canmore branch ability to repay its line of credit including any interest. Management has provided the following list of assumptions to help in the preparation of the cash budget (note: you will need to use the projected income statement provided in Question 4 to complete the cash budget): 1. Beginning cash balance invested by owners 52,000 \begin{tabular}{|l|l|l|l|l|r|} \hline & Quarter 1 & Quarter 2 & Quarter 3 & Quarter 4 \\ \hline 2. Sales by quarter (as \% of total projected sales) & 22% & 23% & 28% & \\ \hline \end{tabular} 3. Type of collections from customers: \begin{tabular}{|l|r|} \hline Cash Sales & 37% \\ \hline Credit Sales (accounts receivable) & 63% \\ \hline \end{tabular} Cash sales are collected in the quarter of the sale, all credit sales are collected in the quarter after the sale. 4. Merchandise purchases Merchandise purchases (cost of goods sold) are all paid in the quarter following purchase. (Quarter 1 purchases are bought in Quarter 1 but paid for in quarter 2). 5. Operating expenses All other operating expenses (all expenses except cost of goods sold) are paid on a monthly basis. 6. Required investment in equipment paid in cash in the first quarter 7. Quarterly income tax payments paid in cash 7,000 8. Minimum cash balance 24,000 9. Borrowing and Repayments: Any borrowing will take place on the first day of the quarter and any repayments are paid at the end of the quarter. All borrowing and payments are made in increments of $1,000. Interest on borrowing can be ignored. D Bet iakyotas' in have Question 5 - Cash Budget (30 marks) Mountain Sports has aquired an open line of credit up to a maximum of $350,000. It will be necessary to convince the bank manager of this new Canmore branch ability to repay its line of credit including any interest. Management has provided the following list of assumptions to help in the preparation of the cash budget (note: you will need to use the projected income statement provided in Question 4 to complete the cash budget): 1. Beginning cash balance invested by owners \begin{tabular}{|l|l|l|l|r|} \hline 2. Sales by quarter (as \% of total projected sales) & Quarter 1 & Quarter 2 & Quarter 3 & Quarter 4 \\ \hline \end{tabular} 3. Type of collections from customers: \begin{tabular}{|l|l|} \hline Cash Sales & 37% \\ \hline Credit Sales (accounts receivable) & 63% \\ \hline \end{tabular} Cash sales are collected in the quarter of the sale, all credit sales are collected in the quarter after the sale. 4. Merchandise purchases Merchandise purchases (cost of goods sold) are all paid in the quarter following purchase. (Quarter 1 purchases are bought in Quarter 1 but paid for in quarter 2). 5. Operating expenses All other operating expenses (all expenses except cost of goods sold) are paid on a monthly basis. 6. Required investment in equipment paid in cash in the first quarter 7. Quarterly income tax payments paid in cash 133,000 8. Minimum cash balance 9. Borrowing and Repayments: Any borrowing will take place on the first day of the quarter and any repayments are paid at the end of the quarter. All borrowing and payments are made in increments of $1,000. Interest on borrowing can be ignored. Required: Prepare a cash budget for the first year of operation in Canmore by quarter and in total. Show clearly on your budget the quarter(s) in which borrowing will be needed and the quarter(s) in which repayments can be made, as requested by the company's bank. Question 5 - Cash Budget (30 marks) Mountain Sports has acquired an open line of credit up to a maximum of $350,000. It will be necessary to convince the bank manager of this new Canmore branch ability to repay its line of credit including any interest. Refer to the excel file for the following required tasks: - Part 5A: Chapter 10 (30 marks) Prepare a cash budget for the first year of operation in Canmore by quarter and in total. Show clearly on your budget the quarter(s) in which borrowing will be needed and the quarter(s) in which repayments can be made, as requested by the company's bank. Question 5 Check Figures 32 Be rerspues's buek. Question 5 - Cash Budget (30 marks) Mountain Sports has aquired an open line of credit up to a maximum of $350,000. It will be necessary to convince the bank manager of this new Canmore branch ability to repay its line of credit including any interest. Management has provided the following list of assumptions to help in the preparation of the cash budget (note: you will need to use the projected income statement provided in Question 4 to complete the cash budget): 1. Beginning cash balance invested by owners 52,000 \begin{tabular}{|l|l|l|l|l|r|} \hline & Quarter 1 & Quarter 2 & Quarter 3 & Quarter 4 \\ \hline 2. Sales by quarter (as \% of total projected sales) & 22% & 23% & 28% & \\ \hline \end{tabular} 3. Type of collections from customers: \begin{tabular}{|l|r|} \hline Cash Sales & 37% \\ \hline Credit Sales (accounts receivable) & 63% \\ \hline \end{tabular} Cash sales are collected in the quarter of the sale, all credit sales are collected in the quarter after the sale. 4. Merchandise purchases Merchandise purchases (cost of goods sold) are all paid in the quarter following purchase. (Quarter 1 purchases are bought in Quarter 1 but paid for in quarter 2). 5. Operating expenses All other operating expenses (all expenses except cost of goods sold) are paid on a monthly basis. 6. Required investment in equipment paid in cash in the first quarter 7. Quarterly income tax payments paid in cash 7,000 8. Minimum cash balance 24,000 9. Borrowing and Repayments: Any borrowing will take place on the first day of the quarter and any repayments are paid at the end of the quarter. All borrowing and payments are made in increments of $1,000. Interest on borrowing can be ignored. D 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