The following information is related to a cash financing plan of DIVA Company.

To meet its financial requirements in July 2017, DIVA Company plans to borrow 30 000 kronor from Swedbank with the interest rate is 2% per month.

To meet its financial requirements in August, DIVA Company stretches 20 600 kronor accounts payable (losing 3% discount). Also in August, DIVA Company repays part of the bank loan of 10 000 kronor.

In September 2017, DIVA Company plans to use the excess of net cash inflows to repay the August accounts payable of 20 600 kronor and the remaining bank loan of 20 000 kronor.

Required: Prepare DIVA's financial plan for July, August, and September 2017 using excel. The template for the financial plan can follow the given table:

DIVA COMPANY Financing Plan July, August, and September 2017 Month: July August Sept A. Cash requirements Cash required for operations 30 000 10 000 -60 000 Interest on bank loan Interest in delaying payables Total cash required B. Cash raised in month Bank Loan Delaying payables Total cash raised C. Repayments Of delaying payables Of bank loan Total repayments D. Addition to cash balances E. Bank Loan Beginning of month Ending of month