Question: Willie Wong has recently purchased a microcomputer system and has decided to set up a cash flow spreadsheet which will allow him to analyse

Willie Wong has recently purchased a microcomputer system and has decided to

Willie Wong has recently purchased a microcomputer system and has decided to set up a cash flow spreadsheet which will allow him to analyse his personal finances over the next six months (January-June). His only source of income is his annual net salary of 18,000. After examining his bank statements for the past year, Willie has worked out average expenses. These include monthly payments for rent (250), food (150), car expenses (90), and sundries (100) as well as two monthly bills for electricity (100) and telephone calls (70). Because of his recent microcomputer purchase, Willie has estimated that he will have a bank overdraft of 2000 on 1 January. Willie Wong intends to take a holiday in July and he would like to know how much money will be available. Set up a cash flow model showing net cash flows and balances at the end of each month. How much will Willie have for his holiday?

Step by Step Solution

3.37 Rating (156 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

ANSWER I To set up a cash flow model we need to list down all the cash inflows and outflows for each ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!