## (Answered)-Hi, I was not given instructions on how to solve this problem. I

Hi,

I was not given instructions on how to solve this problem. ?I don't know which numbers are to be used to calculate materials purchased. Is it 50 % of a combination of November and December's combined total collections? ?How is interest calculated? Am I to calculate 10% of capital expenditures and dividends or just enter 10%? ?Is there a spreadsheet guide that I can purchase that has these answers for how to complete the rest of the form? ?Any assistance would be appreciated.

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

\$12,000.00

December

\$15,000.00

14,000.00

\$ 12,000.00

\$ 29,000.00

10.00%

\$5,000.00

\$7,500.00

January

February

\$14,400.00 \$16,500.00

17,500.00

14,400.00

14,000.00

17,500.00

\$ 45,900.00 \$ 48,400.00

\$14,500.00

6,000.00

3,000.00

6,000.00

3,500.00

March

April

May

June

\$35,000.00

\$50,000.00

\$65,000.00

\$40,000.00

March

April

May

June

\$27,000.00 \$15,000.00 \$19,500.00 \$12,000.00

19,250.00

27,000.00

15,000.00

22,750.00

14,400.00

19,250.00

27,000.00

15,000.00

\$ 60,650.00 \$ 61,250.00 \$ 61,500.00 \$ 49,750.00

6,000.00

3,000.00

6,000.00

3,200.00

45,000.00

1,000.00

6,000.00

3,500.00

6,000.00

3,000.00

1,000.00

4,600.00

Solution details:
STATUS
QUALITY
Approved

This question was answered on: Oct 07, 2020

Solution~0002163460.zip (25.37 KB)

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy (Deadline assured. Flexible pricing. TurnItIn Report provided)

STATUS

QUALITY

Approved

Oct 07, 2020

EXPERT

Tutor