final finance problem i need this tomorrow

final finance problem i need this tomorrow

the first two attachments are examples the last one is the excel spreadsheet that needs to be field out

for the homework below

 

 

 

Complete the following problems. For assistance, you may want to refer to these examples. The Word document has instructions on using the Excel spreadsheet.

 

Required:

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

  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.

  1. Given the following information:

    Sales

    June

    $200,000

    July

    200,000

    August

    200,000

    September

    300,000

    October

    500,000

    November

    200,000

    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.

"Order a similar paper and get 15% discount on your first order with us
Use the following coupon
"FIRST15"

Order Now