Instruction
Make an excel sheet and answer question
Q1) What is the Collections Forecast for April? (example: $123,456) *
Q2) What is the Collections Forecast for June? (example: $123,456) *
Q3) What is the Payments Forecast for April? (example: $123,456) *
Q4) What is the Payments Forecast for June? (example: $123,456) *
Q5) How much cash should be borrowed in April? (example: $12,345) *
Q6) How much cash can be repaid in May? (example: $12,345) *
Q7) How much cash can be repaid in June? (example: $12,345) *
Q8) Conduct scenario Analysis. How much cash can be repaid in May in Good/Best case? (example: $12,345) *
Q9) Conduct scenario Analysis. How much cash can be repaid in May in Bad/Worse case? (example: $12,345) *
Q10) Conduct scenario Analysis. Based on all scenarios, what is the maximum amount the company should plan to borrow ? (example: $12,345) *