Answered step by step
Verified Expert Solution
Question
1 Approved Answer
QUESTION: Create a budgeted balance sheet for this company as at March 31, 2022. A SIMPLE AND CLEAR TABLES ONLY PLEASE! Pele Solar Company is
QUESTION: Create a budgeted balance sheet for this company as at March 31, 2022.
A SIMPLE AND CLEAR TABLES ONLY PLEASE!
Pele Solar Company is a small, rapidly growing wholesaler of solar panels. Bobby Moore, Pele's general manager of marketing, predicts sales of 100,000 units in January 2023, increasing by 15% each month during 2023. Sales revenue in January 2023 is forecast to be $800,000. The sales price will remain constant in 2023. Pele's projected balance sheet as at 31 December 2022 is provided as follows: Cristiano Ronaldo (the assistant accountant) is now preparing a monthly budget for the first quarter of 2023 , and he needs your help. So far, the following information has been accumulated: - Projected sales for December 2022 are $700,000. Credit sales typically are 75 per cent of total sales, with the remainder being cash sales. Pele's credit experience indicates that 10 per cent of the credit sales are collected during the month of sale, and the remainder are collected during the following month. Pele's cost of goods sold generally runs at 70 per cent of sales. Inventory is purchased on credit, and 40 per cent of each month's purchases are paid during the month of purchase. The remainder is paid during the following month. In order to have adequate stocks of inventory on hand, the firm attempts to have inventory at the end of each month equal to one-half of the next month's projected cost of goods sold. Ronaldo has already prepared the purchases budget for the quarter to save you some work: Ronaldo has estimated that Pele's monthly cash expenses will be as follows: Other expenses are listed below: In addition, sales commissions run at the rate of 1 per cent of sales revenue. On January 1, a one-off payment of $175,000 is required to purchase new equipment. No depreciation is required to be calculated for this new equipment. Ronaldo believes that Pele needs to keep a minimum cash balance of $25,000. A short-term credit facility for $100,000 has been arranged with a local bank. The bank has given Pele an introductory offer of 0% interest for the first three months of 2023 , although interest of 12% per annum will apply for amounts borrowed after 31 March 2023. Ronaldo has decided that Pele should re-pay any short-term loan required as soon as possible. Interest on Pele's long-term borrowings is paid semi-annually, on 31 January and 31 July, for the preceding six-month period. Pele Solar Company is a small, rapidly growing wholesaler of solar panels. Bobby Moore, Pele's general manager of marketing, predicts sales of 100,000 units in January 2023, increasing by 15% each month during 2023. Sales revenue in January 2023 is forecast to be $800,000. The sales price will remain constant in 2023. Pele's projected balance sheet as at 31 December 2022 is provided as follows: Cristiano Ronaldo (the assistant accountant) is now preparing a monthly budget for the first quarter of 2023 , and he needs your help. So far, the following information has been accumulated: - Projected sales for December 2022 are $700,000. Credit sales typically are 75 per cent of total sales, with the remainder being cash sales. Pele's credit experience indicates that 10 per cent of the credit sales are collected during the month of sale, and the remainder are collected during the following month. Pele's cost of goods sold generally runs at 70 per cent of sales. Inventory is purchased on credit, and 40 per cent of each month's purchases are paid during the month of purchase. The remainder is paid during the following month. In order to have adequate stocks of inventory on hand, the firm attempts to have inventory at the end of each month equal to one-half of the next month's projected cost of goods sold. Ronaldo has already prepared the purchases budget for the quarter to save you some work: Ronaldo has estimated that Pele's monthly cash expenses will be as follows: Other expenses are listed below: In addition, sales commissions run at the rate of 1 per cent of sales revenue. On January 1, a one-off payment of $175,000 is required to purchase new equipment. No depreciation is required to be calculated for this new equipment. Ronaldo believes that Pele needs to keep a minimum cash balance of $25,000. A short-term credit facility for $100,000 has been arranged with a local bank. The bank has given Pele an introductory offer of 0% interest for the first three months of 2023 , although interest of 12% per annum will apply for amounts borrowed after 31 March 2023. Ronaldo has decided that Pele should re-pay any short-term loan required as soon as possible. Interest on Pele's long-term borrowings is paid semi-annually, on 31 January and 31 July, for the preceding six-month periodStep 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