Question Details

(Solved) I am having Issues in figuring this correctly. The interest is


I am having Issues in figuring this correctly.  The interest is throwing me off and the commutative cash flow.  


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

 


 

10.00%

 

$5,000.00

 

$7,500.00

 


 

November

 


 

December

 


 

January

 


 

$7,500.00

 

$40,000.00

 


 

$19,500.00

 

$50,000.00

 


 

$28,500.00

 

$48,000.00

 


 

November

 

$12,000.00

 


 

December

 

$15,000.00

 

$14,000.00

 


 

$12,000.00

 


 

$29,000.00

 


 

January

 

$14,400.00

 

$17,500.00

 

$14,000.00

 

$45,900.00

 


 

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:

 


 

$20,000.00

 


 

$25,000.00

 

6,000.00

 

3,000.00

 


 

20,000.00

 


 

34,000.00

 


 

$19,500.00

 


 

$28,500.00

 


 

$5,000.00

 

$14,500.00

 


 

$5,000.00

 

$23,500.00

 


 

$40,400.00

 

$88,400.00

 

$5,000.00

 

$35,400.00

 


 

February

 


 

March

 


 

April

 


 

May

 


 

June

 


 

$32,800.00

 

$55,000.00

 


 

$73,230.00

 

$35,000.00

 


 

$41,523.00

 

$50,000.00

 


 

$43,402.30

 

$65,000.00

 


 

-$5,049.77

 

$40,000.00

 


 

February

 

$16,500.00

 

$16,800.00

 

$17,500.00

 

$50,800.00

 


 

March

 

$10,500.00

 

$19,250.00

 

$16,800.00

 

$46,550.00

 


 

April

 

$15,000.00

 

$12,250.00

 

$19,250.00

 

$46,500.00

 


 

May

 

$19,500.00

 

$17,500.00

 

$12,250.00

 

$49,250.00

 


 

June

 

$12,000.00

 

$22,750.00

 

$17,500.00

 

$52,250.00

 


 

$24,000.00

 

6,000.00

 

3,500.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

 


 

33,500.00

 


 

82,500.00

 


 

26,700.00

 


 

34,500.00

 


 

42,500.00

 


 

$50,100.00

 

$105,100.00

 

$5,000.00

 

$45,100.00

 


 

$37,280.00

 

$72,280.00

 

$5,000.00

 

$32,280.00

 


 

$61,323.00

 

$111,323.00

 

$5,000.00

 

$56,323.00

 


 

$58,152.30

 

$123,152.30

 

$5,000.00

 

$53,152.30

 


 

$4,700.23

 

$44,700.23

 

$5,000.00

 

($299.77)

 


 

 


Solution details:

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Oct 15, 2019

EXPERT

Tutor

ANSWER RATING

YES, THIS IS LEGAL

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN A DEADLINE.

Order Now