Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please assist with the attached Budgeting & Pro Forma Financial Statement questions. WK 3 Budgeting & Pro Forma Financial Statements Practical Analysis 1. ABC Company's
Please assist with the attached Budgeting & Pro Forma Financial Statement questions.
WK 3 Budgeting & Pro Forma Financial Statements Practical Analysis 1. ABC Company's has December unit sales of 12,000 units. Assuming a 5% growth, what is the projected unit sale? 2. ABC Company's has December unit sales of 12,000 units. Assuming a 5% growth, and a selling price per unit of $40, what is the projected unit sales? 3. ABC Company projects the next period sales will be 12,000 units. ABC Company desires ending inventory equal to 20% of the next month's sales. What is the desired inventory? 4. ABC Company projects the next period sales will be 12,000 units. ABC Company desires ending inventory equal to 20% of the next month's sales. If the beginning inventory is 100, and the current month's sales are 14,000, what is the number of units that will need to be purchased for the current month? 5. ABC Company has sales forecasts of the following: January = $40,000; February = $65,000; March = $52,850. All sales are on account and are collected as follows: 20% in the current month, 50% in the month following, 25% in the second month following, and 5% uncollectible. What are the cash receipts for March? 6. ABC Company has sales forecasts of the following: February = $40,000; March = $65,000. All sales are on account and are collected as follows: 20% in the current month, 50% in the month following, 25% in the second month following, and 5% uncollectible. If the total cash receipts for March equal $48,250, what is the sales forecast for January? 7. Assume the following information for the month of August. June sales = $40,000; July sales = $65,000; August sales = $52,850. All sales are on account and are collected as follows: 20% in the current month, 50% in the month following, 25% in the second month following, and 5% uncollectible. T he beginning cash balance is $14,670, with cash payment of $24,653. If the minimum cash balance is $50,000, what is the amount needed by the bank, or how much is available to pay towards the bank loan? Show the amount needed as a positive number and the amount to repay a loan as a negative number. 8. Assume the following information for t he month of August. June sales = $40,000; July sales = $65,000; August sales = $52.850. All sales are on account and are collected as follows: 20% in the current month, 50% in the month following, 25% in the second month following, and 5% uncollectable. The beginning cash balance is $14,670, with cash payments of $24,653. If the minimum cash balance is $40,000, what is the amount needed by the bank, or how much is available to pay towards the bank loan? Show the amount needed as a positive number and the amount to repay a loan as a negative number. 9. ABC Company pays for merchandise by paying cash and using credit. Credit purchases equal 80% of the purchases. Of those purchased on credit the purchase are paid for as follows: 60% in the current month, 35% in the month following, and 5% in the second month following. Assume January purchases are $65,000. How much of the January purchases are paid for in January? 10. ABC Company pays for merchandise entirely on credit as follows: 60% in the current month 35% in the month following, and 5% in the second month following. Assume January purchases are $65,000. How much of the January purchases are paid for in JanuaryStep 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