Description of this paper

Loading

Precision Machines Student Note: Fill in the light yellow-(Answered)

Description

Instant Solution ? Click "Buy button" to Download the solution File


Question

I need help with the attached. ?I have tried to complete it; however, my answers or numbers?doesn't match what I found here. ?


Precision Machines

 

Student Note: Fill in the light yellow cells

 

Data:

 

Annual Cost of borrowing

 

Minimum Cash Balance

 

Beginning Cash Balance

 

Revenues (Sales)

 

Cash Collections

 

First Month (30%)

 

Second Month (35%)

 

Third Month (35%)

 

Total Collections

 

Cash Disbursements

 

Material Purchases

 

Salaries

 

Wages

 

Other Expenses

 

Capital Expenditure

 

Dividends

 

Interest

 

Total Disbursements

 

Cash flows

 

Net cash flows

 

Cumulative cash flows

 

Minimum Cash Balance

 

Cash Surplus or (Deficit)

 

Recommendations:

 


 

November

 


 

December

 


 

January

 


 

February

 


 

$40,000.00

 


 

$50,000.00

 


 

$48,000.00

 


 

$55,000.00

 


 

November

 


 

December

 


 

January

 


 

February

 


 

6,000.00

 

3,000.00

 


 

6,000.00

 

3,500.00

 


 

10.00%

 

$5,000.00

 

$7,500.00

 


 

March

 


 

April

 


 

May

 


 

June

 


 

$35,000.00

 


 

$50,000.00

 


 

$65,000.00

 


 

$40,000.00

 


 

March

 


 

April

 


 

May

 


 

June

 


 

6,000.00

 

3,000.00

 


 

6,000.00

 

3,200.00

 


 

6,000.00

 

3,500.00

 


 

6,000.00

 

3,000.00

 


 

45,000.00

 

1,000.00

 


 

1,000.00

 


 

 

Paper#9210205 | Written in 27-Jul-2016

Price : $19
SiteLock