Description of this paper

Loading

I need to help please i not know the certian please suddently-(Answered)

Description

Step-by-step Instant Solution


Question

I need to help please i not know the certian please suddently ??Cash Surplus or (Deficit) ?need to change Green or red, ? and also?Interest - H ? I need help Excel?


22

 

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

 

$12,000.00

 


 

December

 

$15,000.00

 

14,000.00

 


 

12000.00

 


 

29000.00

 


 

January

 

$14,400.00

 

17,500.00

 

14,000.00

 

45900.00

 


 

February

 

$16,500.00

 

16,800.00

 

17,500.00

 

50800.00

 


 

$20,000.00

 


 

$25,000.00

 

6,000.00

 

3,000.00

 


 

$24,000.00

 

6,000.00

 

3,500.00

 


 

0.00

 


 

20,000.00

 


 

34,000.00

 


 

33,500.00

 


 

12000

 

19500

 

5000

 

14500

 


 

9000

 

28500

 

5000

 

23500

 


 

11900

 

40400

 

5000

 

35400

 


 

17300

 

57700

 

5000

 

52700

 


 

10.00%

 

$5,000.00

 

$7,500.00

 


 

30%

 

35%

 

35%

 


 

March

 


 

April

 


 

May

 


 

June

 


 

$35,000.00

 


 

$50,000.00

 


 

$65,000.00

 


 

$40,000.00

 


 

March

 

$10,500.00

 

19,250.00

 

16,800.00

 

46550.00

 


 

April

 

$15,000.00

 

12,250.00

 

19,250.00

 

46500.00

 


 

May

 

$19,500.00

 

17,500.00

 

12,250.00

 

49250.00

 


 

June

 

$12,000.00

 

22,750.00

 

17,500.00

 

52250.00

 


 

$27,500.00

 

6,000.00

 

3,000.00

 


 

$17,500.00

 

6,000.00

 

3,200.00

 


 

$25,000.00

 

6,000.00

 

3,500.00

 


 

$32,500.00

 

6,000.00

 

3,000.00

 


 

45,000.00

 

1,000.00

 


 

1,000.00

 


 

82,500.00

 


 

26,700.00

 


 

34,500.00

 


 

42,500.00

 


 

-35950

 

21750

 

5000

 

16750

 


 

19800

 

41550

 

5000

 

36550

 


 

14750

 

56300

 

5000

 

51300

 


 

9750

 

66050

 

5000

 

61050

 


 

 

Paper#9256269 | Written in 27-Jul-2016

Price : $16
SiteLock