In: Finance
1)Calculate the Cumulative Net amount for this 6-month project. Which month will have the highest demand on your finances? Hint: You are determining what your line of credit amount will be.
2) calculate the interest you will have to pay to cash flow the project. Interest Rate is 5%. Hint: you need to calculate the cumulative monthly amounts to calculate the monthly interest, if any.
| Month | Monthly Net | |
| 1 | $ (28,500) | |
| 2 | $ (14,760) | |
| 3 | $ (5,650) | |
| 4 | $ 200 | |
| 5 | $ 22,690 | |
| 6 | $ 26,020 |
| Response to part 1) | ||||||
| Month | Monthly net (USD) | Cumulative balance (USD) | ||||
| 1 | (28,500) | (28,500) | ||||
| 2 | (14,760) | (43,260) | ||||
| 3 | (5,650) | (48,910) | ||||
| 4 | 200 | (48,710) | ||||
| 5 | 22,690 | (26,020) | ||||
| 6 | 26,020 | - | ||||
| Note : Cumulative balance is calculated as follows : | ||||||
| Monthly net amount for current month + cumulative balance for previous month | ||||||
| Month 1 will have the highest demand on the finances as the amount of outflow is the highest. |
| Response to part 2) | |||
| Month | Monthly net (USD) | Cumulative balance (USD) | Interest @ 5% |
| 1 | (28,500) | (28,500) | (1,425) |
| 2 | (14,760) | (43,260) | (2,163) |
| 3 | (5,650) | (48,910) | (2,446) |
| 4 | 200 | (48,710) | (2,436) |
| 5 | 22,690 | (26,020) | (1,301) |
| 6 | 26,020 | - | - |
| Note : | Interest is taken at 5% and not 5% p.a. as per the question | ||
| Interst = Cumulative balance for current month * 5% |