Preparing a financial budget—schedule of cash receipts sensitivity analysis Marcel Company projects the following sales for the first three months of the year: $11,200 in January; $512,300 in February; and $11,100 in March. The company expects 60% of the sales to be cash and the remainder on account. Sales on account are collected 50% in the month of the sale and 50% in the following month. The Accounts Receivable account has a zero balance on January l. Round to the nearest dollar. Requirements . Prepare a schedule of cash receipts for Marcel for January, February and March. What is the balance in Accounts Receivable on March 31? Prepare a revised schedule of cash receipts if receipts from sales on account are 60% in the month of the sale, 30% in the month following the sale, and 10% in the second month following the sale. What is the balance in Accounts Receivable on March 31?
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
Preparing a financial budget—schedule of cash receipts sensitivity analysis
Marcel Company projects the following sales for the first three months of the year: $11,200 in January; $512,300 in February; and $11,100 in March. The company expects 60% of the sales to be cash and the remainder on account. Sales on account are collected 50% in the month of the sale and 50% in the following month. The
Requirements
- . Prepare a schedule of cash receipts for Marcel for January, February and March. What is the balance in Accounts Receivable on March 31?
- Prepare a revised schedule of cash receipts if receipts from sales on account are 60% in the month of the sale, 30% in the month following the sale, and 10% in the second month following the sale. What is the balance in Accounts Receivable on March 31?
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 17 images
