Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed 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 January

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting Fundamentals With Connect Plus

Authors: John Wild

4th Edition

77785932, 978-0077785932

More Books

Students also viewed these Accounting questions

Question

5. Give some examples of hidden knowledge.

Answered: 1 week ago