Week 11 | Business & Finance homework help

Required:

Download the Week 11 Problems Excel spreadsheetto use in completing your problems.

Don't use plagiarized sources. Get Your Custom Essay on
Week 11 | Business & Finance homework help
Just from $13/Page
Order Essay

1.    Given the following information:

75 percent of sales are for credit, and collections occur after thirty days.
A $100,000 Treasury bill matures in March.
Monthly fixed disbursements are $13,000.
Variable disbursements are 62 percent of sales and occur one month prior to sales.
A tax payment of $13,500 is due in February.
The initial cash is $20,000.
The minimum required cash balance is $5,000.
Variable cash disbursements for April are $30,000.

Sales

January

0

February

60,000

March

80,000

April

100,000

Construct the firm’s cash budget for the given months.

2.    Given the following information:

Sales

June

$200,000

July

200,000

August

200,000

September

300,000

October

500,000

November

200,000

3.   
70% of the sales are for credit and are collected one month after the sale. Other receipts:  $50,000 in October
Variable disbursements: 60% of sales each month
Other disbursements: $10,000 a month
$80,000 for taxes in August
$400,000 for debt repayment in November
Beginning cash: $50,000
Desired cash: $10,000

Prepare a monthly cash budget for this firm

Calculator

Calculate the price of your paper

Total price:$26
Our features

We've got everything to become your favourite writing service

Need a better grade?
We've got you covered.

Order your paper