Answered step by step
Verified Expert Solution
Link Copied!

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:

Ubi Soft

Sales Forecast

Month

Sales

June

$1,050,000

July

950,000

August

1,360,000

September

1,880,000

October

2,290,000

November

2,570,000

December

1,140,000

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

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

Principles Of Auditing And Other Assurance Services

Authors: Ray Whittington, Kurt Pany

19th International Edition

125909524X, 9781259095245

More Books

Students also viewed these Accounting questions