Cashflow forecasts and excel

Select the correct formula for adding up all the numbers from B3 to B7

• =SUM(B3:B7)

• =SUMB3:B7

• SUM(B3:B7)

• =ADD(B3:B7)

Order the headings of the cashflow forecast

• Receipts

• Payments

• Opening bank balance

• Net cash flow

• Closing bank balance

Net cashflow is the ​ (a)   ​ (b)   the ​ (c)  

• total receipts
• total payments
• minus
• plus

To add another ROW, you must right click on the left of the sheet and select:

• Copy

• Insert

• Delete

• Clear contents

To delete a ROW, you must right click on the left of the sheet and select:

• Copy

• Insert

• Delete

• Clear contents

To merge cells A1 and B1, you must select the cells and then:

• Click on Clear contents

• Click on Delete

• Click on Insert

• Click on Merge & Center

Organise the receipts and payments

Groups:

(a) Receipts

,

(b) Payments

• Drawings

• Internet Bill

• Electricity

• Insurance

• Interest Income

• Sale of old van

• Rent

• Paying interest to the bank

• Purchase of new van

• Office Supplies

• Rates

• Receive short term loan from bank

• Sales

Based on this information, what will the opening bank balance for May be?

• 1,500

• 1,900

• 1,100

• 1,300

What will the closing bank balance be?

• 200

• 1,200

• 800

• 1,000

An agreement where a bank lends money at interest in exchange for taking title of the debtor's property

• Mortgage

• Drawings

• Overdraft

• Wages