| FINA310 UNIT 5 INDIVIDUAL PROJECT: STUDENT TEMPLATE |
| KING KARS |
| JANUARY | FEBRUARY | MARCH | APRIL | MAY | JUNE | JULY | AUGUST | SEPTEMBER | OCTOBER | NOVEMBER | DECEMBER |
| GIVEN: | MONTHLY NET CASH GAIN OR LOSS | $ 5,000 | $ (30,000) | $ 20,000 | $ (35,000) | $ 25,000 | $ (10,000) | $ 25,000 | $ 25,000 | $ (30,000) | $ 15,000 | $ 15,000 | $ 25,000 |
| JANUARY | FEBRUARY | MARCH | APRIL | MAY | JUNE | JULY | AUGUST | SEPTEMBER | OCTOBER | NOVEMBER | DECEMBER |
| CASH FLOW SUMMARY |
| 1. Cash balance at start of month |
| 2. Net cash gain (loss) during month |
| 3. Cash bal. at end of month (before financing) |
| 4. Minimum cash balance desired |
| 5. Surplus cash (OR) Deficit cash (Line 3 – Line 4) |
| EXTERNAL FINANCING SUMMARY |
| 6. External financing balance - start of month |
| 7. New financing req'd (negative of Line 5) (if deficit!) |
| 8. Financing repayments (if surplus!) |
| 9. Ext financing balance – end of month |
| 10.Cash bal. at end of mo (Line3 + Line7 + Line8) |
othe1220
FINA310_Unit5_IPStudent_Template_edited1.xlsx
