Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Ubi Soft Entertainment is one of the top ten video game publishers in the world. The company is in the process of developing its cash
Ubi Soft Entertainment is one of the top ten video game publishers in the world. The company is in the process of developing its cash budget for the critical pre-Christmas period (August-November) when it makes about 60% of its sales. 20% of sales are cash; 55% are credit and collected the following month and the remainder is collected two months after the sale.Purchases of raw materials are made in the month prior to the expected sale and average 65% of expected sales. Purchases are paid for in the month following the purchase. Overhead, administration and other expenses are expected to be $244,000 in August and increase by $19,000 in each of the subsequent months. Taxes are $26,000 per month. Interest is$5,000 per month. Cash on hand on July 31 is $43,000. The company likes to maintain a minimum cash balance of $43,000 each month. Actual sales for June and July as well as forecasted sales to the end of the year are provided in the table to the right: |
|
Prepare a cash budget for August, September, October, and November using the template and answer the following questions.
a. What are total cash inflows in September?
b. What are total cash disbursements in October?
c. What is the surplus (additional funds needed) in September?
d. What is the cash balance at the end of November?
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