Business_plan_cash_flow1

xlsx

School

Australian Institute of Management *

*We aren’t endorsed by this school

Course

SITHKOP012

Subject

Accounting

Date

Nov 24, 2024

Type

xlsx

Pages

32

Uploaded by rekhasaini49

Report
Cash in (record when actually recieved) Year * Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 $300,000 $1,200,000 $2,400,000 $4,800,000 $9,600,000 $19,200,000 $38,400,000 $76,800,000 Operating revenue Cash reciepts from customers $100,000 $600,000 $1,200,000 $2,400,000 $4,800,000 $9,600,000 $19,200,000 $38,400,000 Collection of recievables $5,000 $10,000 $20,000 $40,000 $80,000 $160,000 $320,000 $640,000 Other operating revenue received $1,000 $6,000 $12,000 $24,000 $48,000 $96,000 $192,000 $384,000 Total Operating Revenue $106,000 $616,000 $1,232,000 $2,464,000 $4,928,000 $9,856,000 $19,712,000 $39,424,000 Other Sources of Cash Inflows Proceeds from sale of assets 0 0 0 0 0 0 0 0 Funds borrowed $1,000 $2,000 $4,000 $8,000 $16,000 $32,000 $64,000 $128,000 Tax refund/rebates $0 $0 $0 $0 $0 $0 $0 $0 Other sources of cash inflow $0 $0 $0 $0 $0 $0 $0 $0 Total other cash inflows $1,000 $2,000 $4,000 $8,000 $16,000 $32,000 $64,000 $128,000 Total yearly cash in $107,000 $618,000 $1,236,000 $2,472,000 $4,944,000 $9,888,000 $19,776,000 $39,552,000 Cash out (record when actually paid) Inventory (Stock) Stock purchases $20,000 $40,000 $80,000 $160,000 $320,000 $640,000 $1,280,000 $2,560,000 Other Cost of Goods $500 $1,000 $2,000 $4,000 $8,000 $16,000 $32,000 $64,000 Total Cost of Goods $20,500 $41,000 $82,000 $164,000 $328,000 $656,000 $1,312,000 $2,624,000 General & Administrative Bank charges $500 $500 $500 $500 $500 $500 $500 $500 Credit card commission $500 $500 $500 $500 $500 $500 $500 $500 Accounting/Legal/Consultant fees $300 $300 $300 $300 $300 $300 $300 $300 Cash balance at the start of each Year #
Office Supplies $5,000 $7,500 $11,250 $16,875 $25,313 $37,969 $56,953 $85,430 License fees $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 Business insurance $5,000 $6,500 $8,450 $10,985 $14,281 $18,565 $24,134 $31,374 Total General & Administrative $12,300 $16,300 $22,000 $30,160 $41,893 $58,833 $83,387 $119,104 Marketing & Promotional Advertising $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 Promotion - General $500 $500 $500 $500 $500 $500 $500 $500 Promotion - Other $300 $330 $363 $399 $439 $483 $531 $585 Total Marketing & Promotional $2,000 $2,030 $2,063 $2,099 $2,139 $2,183 $2,231 $2,285 Operating Expenses Newspapers & magazines $200 $200 $200 $200 $200 $200 $200 $200 Parking/Taxis/Tolls $50 $50 $50 $50 $50 $50 $50 $50 Entertainment/Meals $500 $500 $500 $500 $500 $500 $500 $500 Travel/Accomodation $300 $300 $300 $300 $300 $300 $300 $300 Laundry/dry cleaning $30 $30 $30 $30 $30 $30 $30 $30 Equipment hire $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 Total Operating Expenses $2,080 $2,080 $2,080 $2,080 $2,080 $2,080 $2,080 $2,080 Motor Vehicle Expenses Fuel $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 Vehicle service costs $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 Insurance $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 Registrations $100 $100 $100 $100 $100 $100 $100 $100 Total Motor Vehicle Expenses $5,100 $5,100 $5,100 $5,100 $5,100 $5,100 $5,100 $5,100 Website Expenses Domain name registration $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 Hosting expenses $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
etc $0 $0 $0 $0 $0 $0 $0 $0 Total Website Expenses $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 Employment Expenses Permanent Salaries/Wages $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 PAYE $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 Other - Employee Benefits $500 $550 $605 $666 $732 $805 $886 $974 Recruitment costs $100 $100 $100 $100 $100 $100 $100 $100 Total Perm. Employ Exp $101,600 $101,650 $101,705 $101,766 $101,832 $101,905 $101,986 $102,074 Occupancy Costs Electricity/Gas $1,000 $1,100 $1,210 $1,331 $1,464 $1,611 $1,772 $1,949 Telephones $100 $100 $100 $100 $100 $100 $100 $100 Property Insurance $20,000 $21,000 $22,050 $23,153 $24,310 $25,526 $26,802 $28,142 Rates $20 $20 $20 $20 $20 $20 $20 $20 Rent $0 $0 $0 $0 $0 $0 $0 $0 Repair & maintenance $300 $330 $363 $399 $439 $483 $531 $585 Waste removal $100 $100 $100 $100 $100 $100 $100 $100 Water $150 $150 $150 $150 $150 $150 $150 $150 Total Occupancy Costs $21,670 $22,800 $23,993 $25,253 $26,583 $27,989 $29,475 $31,045 Other Expenses Bank Interest $400 $400 $400 $400 $400 $400 $400 $400 Total Other Expenses $400 $400 $400 $400 $400 $400 $400 $400 Other Cash Outflows Purchase of assets $2,000 $2,200 $2,420 $2,662 $2,928 $3,221 $3,543 $3,897 Principal Loan repayments $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Investment of surplus funds. $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 Other cash inflows $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 Total Other Cash Outflows $104,000 $104,200 $104,420 $104,662 $104,928 $105,221 $105,543 $105,897 Total Yearly cash out $170,050 $195,910 $244,056 $335,754 $513,124 $859,807 $1,542,217 $2,891,911 -$63,050 $422,090 $991,944 $2,136,246 $4,430,876 $9,028,193 $18,233,783 $36,660,089 $236,950 $1,622,090 $3,391,944 $6,936,246 $14,030,876 $28,228,193 $56,633,783 $113,460,089 Net difference Cash balance at the end of each Year
Year 9 Year 10 Total $153,600,000 $307,200,000 $613,500,000 $76,800,000 $153,600,000 $306,700,000 $1,280,000 $2,560,000 $5,115,000 $768,000 $1,536,000 $3,067,000 $78,848,000 $157,696,000 $314,882,000 0 0 $0 $256,000 $512,000 $1,023,000 $0 $0 $0 $0 $0 $0 $256,000 $512,000 $1,023,000 $79,104,000 $158,208,000 $315,905,000 $5,120,000 $10,240,000 $20,460,000 $128,000 $256,000 $511,500 $5,248,000 $10,496,000 $20,971,500 $500 $500 $5,000 $500 $500 $5,000 $300 $300 $3,000
$128,145 $192,217 $566,650 $1,000 $1,000 $10,000 $40,787 $53,022 $213,097 $171,231 $247,539 $802,748 $1,200 $1,200 $12,000 $500 $500 $5,000 $643 $707 $4,781 $2,343 $2,407 $21,781 $200 $200 $2,000 $50 $50 $500 $500 $500 $5,000 $300 $300 $3,000 $30 $30 $300 $1,000 $1,000 $10,000 $2,080 $2,080 $20,800 $2,000 $2,000 $20,000 $2,000 $2,000 $20,000 $1,000 $1,000 $10,000 $100 $100 $1,000 $5,100 $5,100 $51,000 $1,000 $1,000 $10,000 $1,000 $1,000 $10,000
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
$0 $0 $0 $2,000 $2,000 $20,000 $100,000 $100,000 $1,000,000 $1,000 $1,000 $10,000 $1,072 $1,179 $7,969 $100 $100 $1,000 $102,172 $102,279 $1,018,969 $2,144 $2,358 $15,937 $100 $100 $1,000 $29,549 $31,027 $251,558 $20 $20 $200 $0 $0 $0 $643 $707 $4,781 $100 $100 $1,000 $150 $150 $1,500 $32,706 $34,462 $275,977 $400 $400 $4,000 $400 $400 $4,000 $4,287 $4,716 $31,875 $1,000 $1,000 $10,000
$100,000 $100,000 $1,000,000 $1,000 $1,000 $10,000 $106,287 $106,716 $1,051,875 $5,570,147 $10,896,704 $23,219,680 $73,533,853 $147,311,296 $227,133,853 $454,511,296
Changes in expenses 0 Year * Year 1 Year 2 Year 3 $300,000 $1,200,000 $2,400,000 Cash in (record when actually recieved) Operating revenue $100,000 $600,000 $1,200,000 Collection of recievables $5,000 $10,000 $20,000 $1,000 $6,000 $12,000 Total Operating Revenue $106,000 $616,000 $1,232,000 Other Sources of Cash Inflows Proceeds from sale of assets 0 0 0 Funds borrowed 1,000 2,000 4,000 Tax refund/rebates 0 0 0 Other sources of cash inflow 0 0 0 Total other cash inflows $1,000 $2,000 $4,000 Total yearly cash in $107,000 $618,000 $1,236,000 Cash out (record when actually paid) Total Cost of Goods $20,500 $41,000 $82,000 $12,300 $16,300 $22,000 $2,000 $2,030 $2,063 Total Operating Expenses $2,080 $2,080 $2,080 Total Motor Vehicle Expenses $5,100 $5,100 $5,100 Total Website Expenses $2,000 $2,000 $2,000 Total Perm. Employ Exp $101,600 $101,650 $101,705 Total Occupancy Costs $21,670 $22,800 $23,993 Total Other Expenses $400 $400 $400 Other Cash Outflows Purchase of assets 2,000 2,200 2,420 Principal Loan repayments 1,000 1,000 1,000 Investment of surplus funds. 100,000 100,000 100,000 Other cash inflows 1,000 1,000 1,000 Total Other Cash Inflows $104,000 $104,200 $104,420 Total monthly cash out $170,050 $195,910 $244,056 Cash balance at the start of each Year Cash reciepts from customers Other operating revenue received Total General & Administrative Total Marketing & Promotional
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
-$63,050 $422,090 $991,944 $236,950 $1,622,090 $3,391,944 Net difference (subtracts the Cash out from Cash in) Cash balance at the end of each year
Year 4 Year 5 Year 6 Year 7 $4,800,000 $9,600,000 $19,200,000 $38,400,000 $2,400,000 $4,800,000 $9,600,000 $19,200,000 $40,000 $80,000 $160,000 $320,000 $24,000 $48,000 $96,000 $192,000 $2,464,000 $4,928,000 $9,856,000 $19,712,000 0 0 0 0 8,000 16,000 32,000 64,000 0 0 0 0 0 0 0 0 $8,000 $16,000 $32,000 $64,000 $2,472,000 $4,944,000 $9,888,000 $19,776,000 $164,000 $328,000 $656,000 $1,312,000 $30,160 $41,893 $58,833 $83,387 $2,099 $2,139 $2,183 $2,231 $2,080 $2,080 $2,080 $2,080 $5,100 $5,100 $5,100 $5,100 $2,000 $2,000 $2,000 $2,000 $101,766 $101,832 $101,905 $101,986 $25,253 $26,583 $27,989 $29,475 $400 $400 $400 $400 2,662 2,928 3,221 3,543 1,000 1,000 1,000 1,000 100,000 100,000 100,000 100,000 1,000 1,000 1,000 1,000 $104,662 $104,928 $105,221 $105,543 $335,754 $513,124 $859,807 $1,542,217
$2,136,246 $4,430,876 $9,028,193 $18,233,783 $6,936,246 $14,030,876 $28,228,193 $56,633,783
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Year 8 Year 9 Year 10 Total $76,800,000 $153,600,000 $307,200,000 $38,400,000 $76,800,000 $153,600,000 $306,700,000 $640,000 $1,280,000 $2,560,000 $5,115,000 $384,000 $768,000 $1,536,000 $3,067,000 $39,424,000 $78,848,000 $157,696,000 $314,882,000 0 0 0 0 128,000 256,000 512,000 1,023,000 0 0 0 0 0 0 0 0 $128,000 $256,000 $512,000 $1,023,000 $39,552,000 $79,104,000 $158,208,000 $315,905,000 $2,624,000 $5,248,000 $10,496,000 $20,971,500 $119,104 $171,231 $247,539 $802,748 $2,285 $2,343 $2,407 $21,781 $2,080 $2,080 $2,080 $20,800 $5,100 $5,100 $5,100 $51,000 $2,000 $2,000 $2,000 $20,000 $102,074 $102,172 $102,279 $1,018,969 $31,045 $32,706 $34,462 $275,977 $400 $400 $400 $4,000 3,897 4,287 4,716 31,875 1,000 1,000 1,000 10,000 100,000 100,000 100,000 1,000,000 1,000 1,000 1,000 10,000 $105,897 $106,287 $106,716 $1,051,875 $2,891,911 $5,570,147 $10,896,704 $23,219,680
$36,660,089 $73,533,853 $147,311,296 $113,460,089 $227,133,853 $454,511,296
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Estimated vs actual worksheet Year* Year 1 Year 2 Year 3 Estimated Actual Estimated Actual Estimated Actual $300,000 $1,200,000 $0 $2,400,000 $0 Cash in (record when actually recieved) Operating revenue $100,000 $600,000 $1,200,000 Collection of recievables $5,000 $10,000 $20,000 $1,000 $6,000 $12,000 Total Operating Revenue $106,000 $0 $616,000 $0 $1,232,000 $0 Other Sources of Cash Inflows Proceeds from sale of assets 0 0 0 Funds borrowed 1,000 2,000 4,000 Tax refund/rebates 0 0 0 Other sources of cash inflow 0 0 0 Total other cash inflows $1,000 $0 $2,000 $0 $4,000 $0 Total yearly cash in $107,000 $0 $618,000 $0 $1,236,000 $0 Cash out (record when actually paid) Inventory (Stock) Stock purchases 20,000 40,000 80,000 Other Cost of Goods 500 1,000 2,000 Total Cost of Goods $20,500 $0 $41,000 $0 $82,000 $0 General & Administrative Bank charges 500 500 500 Credit card commission 500 500 500 300 300 300 Office Supplies 5,000 7,500 11,250 License fees 1,000 1,000 1,000 Business insurance 5,000 6,500 8,450 $12,300 $0 $16,300 $0 $22,000 $0 Marketing & Promotional Advertising 1,200 1,200 1,200 Promotion - General 500 500 500 Cash balance at the start of each year Cash reciepts from customers Other operating revenue received Accounting/Legal/Consultant fees Total General & Administrative
Promotion - Other 300 330 363 $2,000 $0 $2,030 $0 $2,063 $0 Operating Expenses Newspapers & magazines 200 200 200 Parking/Taxis/Tolls 50 50 50 Entertainment/Meals 500 500 500 Travel/Accomodation 300 300 300 Laundry/dry cleaning 30 30 30 Equipment hire 1,000 1,000 1,000 Total Operating Expenses $2,080 $0 $2,080 $0 $2,080 $0 Motor Vehicle Expenses Fuel 2,000 2,000 2,000 Vehicle service costs 2,000 2,000 2,000 Insurance 1,000 1,000 1,000 Registrations 100 100 100 $5,100 $0 $5,100 $0 $5,100 $0 Website Expenses Domain name registration 1,000 1,000 1,000 Hosting expenses 1,000 1,000 1,000 etc 0 0 0 Total Website Expenses $2,000 $0 $2,000 $0 $2,000 $0 Employment Expenses Permanent Salaries/Wages 100,000 100,000 100,000 PAYE 1,000 1,000 1,000 Other - Employee Benefits 500 550 605 Recruitment costs 100 100 100 Total Perm. Employ Exp $101,600 $0 $101,650 $0 $101,705 $0 Occupancy Costs Electricity/Gas 1,000 1,100 1,210 Telephones 100 100 100 Property Insurance 20,000 21,000 22,050 Rates 20 20 20 Rent 0 0 0 Total Marketing & Promotional Total Motor Vehicle Expenses
Repair & maintenance 300 330 363 Waste removal 100 100 100 Water 150 150 150 Total Occupancy Costs $21,670 $0 $22,800 $0 $23,993 $0 Other Expenses Bank Interest 400 400 400 Total Other Expenses $400 $0 $400 $0 $400 $0 Other Cash Outflows Purchase of assets 2,000 2,200 2,420 Principal Loan repayments 1,000 1,000 1,000 Investment of surplus funds. 100,000 100,000 100,000 Other cash inflows 1,000 1,000 1,000 Total Other Cash Inflows $104,000 $0 $104,200 $0 $104,420 $0 Total yearly cash out $170,050 $0 $195,910 $0 $244,056 $0 -$63,050 $0 $422,090 $0 $991,944 $0 $236,950 $0 $1,622,090 $0 $3,391,944 $0 Net difference Cash balance at the end of each year
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Year 4 Year 5 Year 6 Year 7 Estimated Actual Estimated Actual Estimated Actual Estimated Actual $4,800,000 $0 $9,600,000 $0 $19,200,000 $0 $38,400,000 $0 $2,400,000 $4,800,000 $9,600,000 $19,200,000 $40,000 $80,000 $160,000 $320,000 $24,000 $48,000 $96,000 $192,000 $2,464,000 $0 $4,928,000 $0 $9,856,000 $0 $19,712,000 $0 0 0 0 0 8,000 16,000 32,000 64,000 0 0 0 0 0 0 0 0 $8,000 $0 $16,000 $0 $32,000 $0 $64,000 $0 $2,472,000 $0 $4,944,000 $0 $9,888,000 $0 $19,776,000 $0 160,000 320,000 640,000 1,280,000 4,000 8,000 16,000 32,000 $164,000 $0 $328,000 $0 $656,000 $0 $1,312,000 $0 500 500 500 500 500 500 500 500 300 300 300 300 16,875 25,313 37,969 56,953 1,000 1,000 1,000 1,000 10,985 14,281 18,565 24,134 $30,160 $0 $41,893 $0 $58,833 $0 $83,387 $0 1,200 1,200 1,200 1,200 500 500 500 500
399 439 483 531 $2,099 $0 $2,139 $0 $2,183 $0 $2,231 $0 200 200 200 200 50 50 50 50 500 500 500 500 300 300 300 300 30 30 30 30 1,000 1,000 1,000 1,000 $2,080 $0 $2,080 $0 $2,080 $0 $2,080 $0 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 1,000 1,000 1,000 1,000 100 100 100 100 $5,100 $0 $5,100 $0 $5,100 $0 $5,100 $0 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 0 0 0 0 $2,000 $0 $2,000 $0 $2,000 $0 $2,000 $0 100,000 100,000 100,000 100,000 1,000 1,000 1,000 1,000 666 732 805 886 100 100 100 100 $101,766 $0 $101,832 $0 $101,905 $0 $101,986 $0 1,331 1,464 1,611 1,772 100 100 100 100 23,153 24,310 25,526 26,802 20 20 20 20 0 0 0 0
399 439 483 531 100 100 100 100 150 150 150 150 $25,253 $0 $26,583 $0 $27,989 $0 $29,475 $0 400 400 400 400 $400 $0 $400 $0 $400 $0 $400 $0 2,662 2,928 3,221 3,543 1,000 1,000 1,000 1,000 100,000 100,000 100,000 100,000 1,000 1,000 1,000 1,000 $104,662 $0 $104,928 $0 $105,221 $0 $105,543 $0 $335,754 $0 $513,124 $0 $859,807 $0 $1,542,217 $0 $2,136,246 $0 $4,430,876 $0 $9,028,193 $0 $18,233,783 $0 $6,936,246 $0 $14,030,876 $0 $28,228,193 $0 $56,633,783 $0
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Year 8 Year 9 Year 10 Estimated Actual Estimated Actual Estimated $76,800,000 $0 $153,600,000 $0 $307,200,000 $38,400,000 $76,800,000 $153,600,000 $640,000 $1,280,000 $2,560,000 $384,000 $768,000 $1,536,000 $39,424,000 $0 $78,848,000 $0 $157,696,000 0 0 0 128,000 256,000 512,000 0 0 0 0 0 0 $128,000 $0 $256,000 $0 $512,000 $39,552,000 $0 $79,104,000 $0 $158,208,000 2,560,000 5,120,000 10,240,000 64,000 128,000 256,000 $2,624,000 $0 $5,248,000 $0 $10,496,000 500 500 500 500 500 500 300 300 300 85,430 128,145 192,217 1,000 1,000 1,000 31,374 40,787 53,022 $119,104 $0 $171,231 $0 $247,539 1,200 1,200 1,200 500 500 500
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
585 643 707 $2,285 $0 $2,343 $0 $2,407 200 200 200 50 50 50 500 500 500 300 300 300 30 30 30 1,000 1,000 1,000 $2,080 $0 $2,080 $0 $2,080 2,000 2,000 2,000 2,000 2,000 2,000 1,000 1,000 1,000 100 100 100 $5,100 $0 $5,100 $0 $5,100 1,000 1,000 1,000 1,000 1,000 1,000 0 0 0 $2,000 $0 $2,000 $0 $2,000 100,000 100,000 100,000 1,000 1,000 1,000 974 1,072 1,179 100 100 100 $102,074 $0 $102,172 $0 $102,279 1,949 2,144 2,358 100 100 100 28,142 29,549 31,027 20 20 20 0 0 0
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
585 643 707 100 100 100 150 150 150 $31,045 $0 $32,706 $0 $34,462 400 400 400 $400 $0 $400 $0 $400 3,897 4,287 4,716 1,000 1,000 1,000 100,000 100,000 100,000 1,000 1,000 1,000 $105,897 $0 $106,287 $0 $106,716 $2,891,911 $0 $5,570,147 $0 $10,896,704 $36,660,089 $0 $73,533,853 $0 $147,311,296 $113,460,089 $0 $227,133,853 $0 $454,511,296
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Example Cashflow Forecast Worksheet Instructions for the cashflow worksheet Use this worksheet to forecast and record cash flow. The worksheet will update your figures as you type. 1. Type your cash balance at the beginning in cell B10 2. Type in your monthly figures for cash in and cash out, month by month. 3. To use the worksheet as part of a business plan, fill out as much as you can with projections and replace 4. Use the cash flow scenario planner and report to test what will happen if something changes e.g. expens Cash flow scenario planner Changes in sales in 0 Changes in expense 0 Cash in (record when actually recieved) Month * $5,000 -$40,137 -$92,249 -$148,492 -$210,722 -$276,675 -$345,986 -$417,474 $2,200 $2,200 $2,420 $2,640 $2,772 $2,860 $3,080 $3,168 $2,745 $3,102 $3,258 $3,498 $3,795 $4,046 $4,217 $4,475 $0 $0 $0 $0 $0 $0 $0 $0 $4,945 $5,302 $5,678 $6,138 $6,567 $6,906 $7,297 $7,643 $2,200 $2,200 $2,420 $2,640 $2,772 $2,860 $3,080 $3,168 Funds borrowed $2,745 $3,102 $3,258 $3,498 $3,795 $4,046 $4,217 $4,475 Tax refund/rebates $800 $3,000 $2,640 $3,168 $3,300 $3,388 $3,212 $2,200 $2,000 $2,000 $3,498 $4,475 $4,778 $4,891 $4,666 $3,102 $7,745 $10,302 $11,816 $13,781 $14,645 $15,185 $15,175 $12,945 $12,690 $15,604 $17,494 $19,919 $21,212 $22,091 $22,472 $20,588 Cash out (record when actually paid) Inventory (Stock) Stock purchases $2,200 $2,200 $2,420 $2,640 $2,772 $2,860 $3,080 $3,168 $2,745 $3,102 $3,258 $3,498 $3,795 $4,046 $4,217 $4,475 $800 $3,000 $2,640 $3,168 $3,300 $3,388 $3,212 $2,200 General & Administ $2,000 $2,000 $3,498 $4,475 $4,778 $4,891 $4,666 $3,102 Month one, e.g. January Month two, e.g. February Month three, e.g. March Month four, e.g. April Month five, e.g. May Month six, e.g. June Month seven, e.g. July Month eight, e.g. August Cash balance at the start of each month # Operating revenue Cash reciepts from customers Collection of recievables Other operating revenue received Total Operating Revenue Other Sources of Cash Inflows Proceeds from sale of assets Other sources of cash inflow Total other cash inflows Total monthly cash in Other Cost of Goods Total Cost of Goods
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Bank charges 17 17 17 17 20 18 20 20 $2,200 $2,200 $2,420 $2,640 $2,772 $2,860 $3,080 $3,168 $2,745 $3,102 $3,258 $3,498 $3,795 $4,046 $4,217 $4,475 Office Supplies $800 $3,000 $2,640 $3,168 $3,300 $3,388 $3,212 $2,200 License fees $2,000 $2,000 $3,498 $4,475 $4,778 $4,891 $4,666 $3,102 Business insurance Etc. $7,762 $10,319 $11,833 $13,798 $14,665 $15,203 $15,195 $12,965 Marketing & Promotional Advertising $2,200 $2,200 $2,420 $2,640 $2,772 $2,860 $3,080 $3,168 $2,745 $3,102 $3,258 $3,498 $3,795 $4,046 $4,217 $4,475 Promotion - Other $800 $3,000 $2,640 $3,168 $3,300 $3,388 $3,212 $2,200 Etc. $2,000 $2,000 $3,498 $4,475 $4,778 $4,891 $4,666 $3,102 $7,745 $10,302 $11,816 $13,781 $14,645 $15,185 $15,175 $12,945 Operating Expenses $2,200 $2,200 $2,420 $2,640 $2,772 $2,860 $3,080 $3,168 Parking/Taxis/Tolls $2,745 $3,102 $3,258 $3,498 $3,795 $4,046 $4,217 $4,475 $0 $0 $0 $0 $0 $0 $0 $0 $2,200 $2,200 $2,420 $2,640 $2,772 $2,860 $3,080 $3,168 $2,745 $3,102 $3,258 $3,498 $3,795 $4,046 $4,217 $4,475 Sundry supplies $0 $0 $0 $0 $0 $0 $0 $0 Equipment hire Etc. $9,890 $10,604 $11,356 $12,276 $13,134 $13,812 $14,594 $15,286 Motor Vehicle Expenses Fuel 500 358 275 302 330 $2,200 $2,200 $2,420 $2,640 $2,772 $2,860 $3,080 $3,168 $2,745 $3,102 $3,258 $3,498 $3,795 $4,046 $4,217 $4,475 Insurance $0 $0 $0 $0 $0 $0 $0 $0 Registrations $4,945 $5,302 $5,678 $6,638 $6,925 $7,181 $7,599 $7,973 Website Expenses Credit card commission Accounting/Legal/C onsultant fees Total General & Administrative Promotion - General Total Marketing & Promotional Newspapers & magazines Entertainment/Meal s Travel/Accomodatio n Laundry/dry cleaning Cleaning & cleaning products Total Operating Expenses Vehicle service costs Tyres & other replacement costs Total Motor Vehicle Expenses
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
$2,200 $2,200 $2,420 $2,640 $2,772 $2,860 $3,080 $3,168 Hosting expenses $2,745 $3,102 $3,258 $3,498 $3,795 $4,046 $4,217 $4,475 etc $0 $0 $0 $0 $0 $0 $0 $0 Total Website Expe $4,945 $5,302 $5,678 $6,138 $6,567 $6,906 $7,297 $7,643 Employment Expenses Permanent Salaries/Wages 1,230 1,230 1,230 1,230 1,230 1,230 1,230 1,230 PAYE 260 260 260 260 260 260 260 260 Superannuation 135 135 135 135 135 135 135 135 Recruitment costs $1,625 $1,625 $1,625 $1,625 $1,625 $1,625 $1,625 $1,625 Casual Salaries/Wages $2,200 $2,200 $2,420 $2,640 $2,772 $2,860 $3,080 $3,168 PAYE $2,745 $3,102 $3,258 $3,498 $3,795 $4,046 $4,217 $4,475 Superannuation $0 $0 $0 $0 $0 $0 $0 $0 Recruitment costs $4,945 $5,302 $5,678 $6,138 $6,567 $6,906 $7,297 $7,643 $6,570 $6,927 $7,303 $7,763 $8,192 $8,531 $8,922 $9,268 Occupancy Costs Electricity/Gas 130 130 Telephones 30 54 64 43 36 43 75 26 Property Insurance 305 Rates Rent $2,200 $2,200 $2,420 $2,640 $2,772 $2,860 $3,080 $3,168 Waste removal $2,745 $3,102 $3,258 $3,498 $3,795 $4,046 $4,217 $4,475 Water $0 $0 $0 $0 $0 $0 $0 $0 Etc. Total Occupancy C $5,280 $5,356 $5,742 $6,311 $6,603 $6,949 $7,372 $7,799 Other Expenses Bank Interest GST 335 435 Total Other Expens $0 $0 $335 $0 $0 $435 $0 $0 Other Cash Outflows Purchase of assets $2,200 $2,200 $2,420 $2,640 $2,772 $2,860 $3,080 $3,168 Domain name registration Other - Employee Benefits Total Perm. Employ Exp Other - Employee Benefits Total Casual Employ Exp Workcover Insurance Total Employment Expenses Repair & maintenance
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
One-off bank fees $2,745 $3,102 $3,258 $3,498 $3,795 $4,046 $4,217 $4,475 $0 $0 $0 $0 $0 $0 $0 $0 $2,200 $2,200 $2,420 $2,640 $2,772 $2,860 $3,080 $3,168 $2,745 $3,102 $3,258 $3,498 $3,795 $4,046 $4,217 $4,475 Other cash inflows $0 $0 $0 $0 $0 $0 $0 $0 Total Other Cash O $9,890 $10,604 $11,356 $12,276 $13,134 $13,812 $14,594 $15,286 $57,827 $67,716 $73,737 $82,149 $87,165 $91,402 $93,960 $91,365 -$45,137 -$52,112 -$56,243 -$62,230 -$65,953 -$69,311 -$71,488 -$70,777 -$40,137 -$92,249 -$148,492 -$210,722 -$276,675 -$345,986 -$417,474 -$488,251 Notes: * You may wish to write in the names of the months under the numbers to keep track. 'Month one' is the mo Net difference shows if more cash came in, than went out, or vice versa; and how much. The State of Victoria does not make any representations or warranties (expressed or implied) as to the accu The State of Victoria, its employees and agents do not accept any liability to any person for the information o Authorised by the Victorian Government, 121 Exhibition Street, Melbourne, 3000. © Department of State De Principal Loan repayments Payments to the owner/s Investment of surplus funds. Total monthly cash out Net difference Cash balance at the end of each month ‡ To get the cash balance (last row), add or subtract the Net difference from the Cash balance at the star Disclaimer: The information contained in this publication is provided for general guidance only.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
these with real figures when you have them. ses go up by 5%, -$488,251 -$564,255 -$639,648 -$707,754 $3,212 $3,300 $3,388 $3,080 $4,666 $4,778 $4,891 $5,016 $0 $0 $0 $0 $7,878 $8,078 $8,279 $8,096 $3,212 $3,300 $3,388 $3,080 $4,666 $4,778 $4,891 $5,016 $2,860 $2,640 $0 $0 $4,046 $3,498 $14,784 $14,216 $8,279 $8,096 $22,662 $22,294 $16,558 $16,192 $3,212 $3,300 $3,388 $3,080 $4,666 $4,778 $4,891 $5,016 $2,860 $2,640 $0 $8,096 $4,046 $3,498 Month nine, e.g. Septemb er Month ten, e.g. October Month eleven, e.g. November Month twelve, e.g. December
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
18 20 18 18 $3,212 $3,300 $3,388 $4,666 $4,778 $4,891 $2,860 $2,640 $0 28 $4,046 $3,498 $14,802 $14,236 $8,297 $46 $3,212 $3,300 $3,388 $4,666 $4,778 $4,891 $2,860 $2,640 $0 $4,046 $3,498 $14,784 $14,216 $8,279 $0 $3,212 $3,300 $3,388 $4,666 $4,778 $4,891 $0 $0 $0 $3,212 $3,300 $3,388 $4,666 $4,778 $4,891 $0 $0 $0 $15,756 $16,156 $16,558 $0 347 275 198 110 $3,212 $3,300 $3,388 $4,666 $4,778 $4,891 $0 $0 $0 $8,225 $8,353 $8,477 $110
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
$3,212 $3,300 $3,388 $4,666 $4,778 $4,891 $0 $0 $0 $7,878 $8,078 $8,279 $0 1,230 1,230 1,230 1,230 260 260 260 260 135 135 135 135 $1,625 $1,625 $1,625 $1,625 $3,212 $3,300 $3,388 $4,666 $4,778 $4,891 $0 $0 $0 $7,878 $8,078 $8,279 $0 $9,503 $9,703 $9,904 $1,625 160 44 71 33 30 $3,212 $3,300 $3,388 $4,666 $4,778 $4,891 $0 $0 $0 $7,922 $8,149 $8,312 $190 1,180 400 $1,180 $0 $0 $400 $3,212 $3,300 $3,388
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
$4,666 $4,778 $4,891 $0 $0 $0 $3,212 $3,300 $3,388 $4,666 $4,778 $4,891 $0 $0 $0 $15,756 $16,156 $16,558 $0 $98,666 $97,687 $84,664 $10,467 -$76,004 -$75,393 -$68,106 $5,725 -$564,255 -$639,648 -$707,754 -$702,029 onth you start the business. uracy, currency or authenticity of the information. or advice which is provided herein. evelopment, Business and Innovation (DSDBI) 2014 rt of the month (top row). This figure becomes the next month's new cash balance.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help