Pro Forma Cash Flow Statement
Pro Forma Cash Flow State
Pro Forma Cash Flow State
Pro Forma Cash Flow Stmtpapa Geos Restaurantpro Forma Cash Flow State
Pro Forma Cash Flow Stmt Papa Geo's Restaurant Pro Forma Cash Flow Statement For the Five Years Year Year Beginning Cash Balance $,,,,,194 Add: Collections 511,,,,,478 Add: Other cash receipts Total Cash Receipts $0 $511,200 $619,800 $645,607 $672,482 $700,478 Total Cash Available for Use $0 $761,200 $740,837 $922,246 $1,122,889 $1,342,672 Less: Cash Disbursements 403,,,,,915 Cost of sales $25,,,,,178 Salary expenses $67,000 $67,000 $67,000 $67,000 $67,000 Payroll expenses $56,000 $56,000 $56,000 $56,000 $56,000 Outside services $1,560 $1,560 $1,560 $1,560 $1,560 Supplies (office and operating) $6,007 $6,007 $6,007 $6,007 $6,007 Repairs and maintenance $67,980 $67,980 $67,980 $67,980 $67,980 Advertising $12,000 $12,000 $12,000 $12,000 $12,000 Car, delivery and travel $0 $0 $0 $0 $0 Accounting and legal $8,908 $8,908 $8,908 $8,908 $8,908 Rent $8,780 $8,780 $8,780 $8,780 $8,780 Telephone $1,278 $1,278 $1,278 $1,278 $1,278 Utilities $890 $890 $890 $890 $890 Insurance $50,789 $50,789 $50,789 $50,789 $50,789 Taxes (real estate, etc.) $1,000 $1,000 $1,000 $1,000 $1,000 Total Disbursements $0 $307,192 $312,192 $314,972 $318,062 $322,370 Cash Surplus/(Deficit) $0 $454,008 $428,645 $607,274 $804,827 $1,020,302 Financing: Owner investment/(distribution) Borrowing $0 $0 $0 $0 $0 $0 Interest payment (minus $) $0 ($4,000) ($4,320) ($4,666) ($5,039) ($5,442) Principal payment (minus $) $50,000 $4,000 $4,320 $4,666 $5,039 $5,442 Net Cash from Financing $50,000 $0 $0 $0 $0 $0 Budgeted Ending Cash Balance $50,000 $454,008 $428,645 $607,274 $804,827 $1,020,302 Net Cash Flow $0 $204,008 $307,608 $330,635 $354,420 $378,108 Business Loan Interest rate (research the rate) 8.0% Term in years 5 Principal borrowed Interest payment (minus $) $0 ($4,000) ($4,320) ($4,666) ($5,039) ($5,442) Principal payment (minus $) $50,000 $4,000 $4,320 $4,666 $5,039 $5,442 Ending Loan Balance $50,000 $54,000 $58,320 $62,986 $68,024 $73,466 The Excel Five Year Pro Forma Cash Flow Statement was developed using a template authored by Irfanullah Jan and retrieved on August 7, 2016 from: Walter A Corrigan: Collection in year 5 of the terminal value of PPE + working capital from the year 0 initial investment. This is the total of the used FMV of your CapEx budget PPE property, plant & equipment + 100% of any investment in inventory. Any funds invested in year 0 to pay startup expenses before the grand opening are not included in the year 5 terminal value of the project - they are a year 1 income statement cost (the owner ate these costs). Walter A Corrigan: Year 0 beginning cash is $0. Any cash borrowed will show up in the ending cash balance as year 0 net cash financing minus cash disbursements. Walter A Corrigan: Project net cash flows include operating cash flows and investing cash flows but not financing cash flows.
The net cash flows can be used to calculate your investment metrics such as NPV, IRR, profitability index and payback. Walter A Corrigan: Enter amount borrowed. The loan amount should be sufficient to cover Section 3.0 CapEx, start-up expenses before the grand opening, an initial inventory if applicable, and probably a contingency fund in the checking account. I would not borrow funds after year 0. If additional external financing is needed enter an owner investment on row 40 in one or more years 0 - 5. You can also show an owner investment repayment by entering a minus amount. Walter A Corrigan: Leave this at 5 years. Walter A Corrigan: The interest should be entered on the income statement as interest expense. Walter A Corrigan: Enter collections from sales. Walter A Corrigan: Enter expenses as positive amounts from the income statement that affect cash. Depreciation and TCE route purchase amortization do not affect cash. Walter A Corrigan: Your first year is either 2016 or 2017. Walter A Corrigan: I would not borrow funds after year 0. If additional external financing is needed enter an owner investment on row 40 in one or more years 0 - 5. You can also show an owner investment repayment by entering a minus amount. WalterC: Year 0 loan payment: No payment in year 0 which is the day the money is borrowed. The first P&I payment is in year 1. WalterC: Beg Cash Bal: You have written over the cell pointer. The Year 1 beginning cash balance is the same as the Year 0 ending cash balance, and so forth for each year. WalterC: Capital Expenditures/Other Year 0 Cash Disbursements: Enter separate lines for Year 0 cash disbursements as positive numbers for spending on CapEx, startup expenses, and any opening inventory (if needed). The startup expenses should be new business expenses and necessary operating expenses for perhaps 4 – 8 weeks before the grand opening. Sheet2 Year Year Beginning balance ,,,,,194 Add sales ,,,,,478 Cash available to use ,,,,122,,342,672 Less disbursements ,,,,,915 Cash surplus ,,,,,090,757 investment 250,000 Minus other payment 250,000 Budgeted ending cash balance 250,,,,,,078,234 Net cash flow ,,,,,563 Interest rate 8% Term in years 5 Principal borrowed 50,000 Ending loan balance 50,,,,, Pro Forma Cash Flow Stmt Name Your Company Pro Forma Cash Flow Statement For the Five Years Enter figures from the other budget schedules. The orange cells include formulas that will populate as data is entered in other cells. Year 0 is the start of the project where funding and startup cost spending occurs before the grand opening. Year Year Walter A Corrigan: Walter A Corrigan: Your first year is either 2016 or 2017. Beginning Cash Balance $0 Walter A Corrigan: Walter A Corrigan: Year 0 beginning cash is $0. Any cash borrowed will show up in the ending cash balance as year 0 net cash financing minus cash disbursements. $0 $0 $0 $0 $0 Add: Collections Walter A Corrigan: Walter A Corrigan: Enter collections from sales. Add: Other cash receipts Total Cash Receipts $0 $0 $0 $0 $0 $0 Total Cash Available for Use $0 $0 $0 $0 $0 $0 Less: Cash Disbursements Walter A Corrigan: Walter A Corrigan: Enter expenses as positive amounts from the income statement that affect cash. Depreciation and TCE route purchase amortization do not affect cash. Cost of sales Salary expenses Payroll expenses Outside services Supplies (office and operating) Repairs and maintenance Advertising Car, delivery and travel Accounting and legal Rent Telephone Utilities Insurance Taxes (real estate, etc.) Other cash disbursements (name it) Other cash disbursements (name it) Other cash disbursements (name it) Other cash disbursements (name it) Startup expenses Initial inventory The Cutting Edge route cost Capital expenditures Total Disbursements $0 $0 $0 $0 $0 $0 Cash Surplus/(Deficit) $0 $0 $0 $0 $0 $0 Financing: Owner investment/(distribution) Borrowing $0 $0 $0 $0 $0 $0 Interest payment (minus $) $0 $0 $0 $0 $0 $0 Principal payment (minus $) $0 $0 $0 $0 $0 $0 Net Cash from Financing $0 $0 $0 $0 $0 $0 Budgeted Ending Cash Balance $0 $0 $0 $0 $0 $0 Net Cash Flow Walter A Corrigan: Walter A Corrigan: Project net cash flows include operating cash flows and investing cash flows but not financing cash flows. The net cash flows can be used to calculate your investment metrics such as NPV, IRR, profitability index and payback. $0 $0 $0 $0 $0 $0 Business Loan Interest rate (research the rate) 8.0% Term in years 5 Walter A Corrigan: Walter A Corrigan: Leave this at 5 years. Principal borrowed Walter A Corrigan: Walter A Corrigan: Enter amount borrowed. The loan amount should be sufficient to cover Section 3.0 CapEx, start-up expenses before the grand opening, an initial inventory if applicable, and probably a contingency fund in the checking account. I would not borrow funds after year 0. If additional external financing is needed enter an owner investment on row 40 in one or more years 0 - 5. You can also show an owner investment repayment by entering a minus amount. Walter A Corrigan: Leave this at 5 years. Walter A Corrigan: The interest should be entered on the income statement as interest expense. Walter A Corrigan: Enter collections from sales. Walter A Corrigan: Enter expenses as positive amounts from the income statement that affect cash. Depreciation and TCE route purchase amortization do not affect cash. Walter A Corrigan: Your first year is either 2016 or 2017. Walter A Corrigan: I would not borrow funds after year 0. If additional external financing is needed enter an owner investment on row 40 in one or more years 0 - 5. You can also show an owner investment repayment by entering a minus amount. WalterC: Year 0 loan payment: No payment in year 0 which is the day the money is borrowed. The first P&I payment is in year 1. WalterC: Beg Cash Bal: You have written over the cell pointer. The Year 1 beginning cash balance is the same as the Year 0 ending cash balance, and so forth for each year. WalterC: Capital Expenditures/Other Year 0 Cash Disbursements: Enter separate lines for Year 0 cash disbursements as positive numbers for spending on CapEx, startup expenses, and any opening inventory (if needed). The startup expenses should be new business expenses and necessary operating expenses for perhaps 4 – 8 weeks before the grand opening. Sheet2 Year Year Year Beginning balance ,,,,,194 Add sales ,,,,,478 Cash available to use ,,,,122,,342,672 Less disbursements ,,,,,915 Cash surplus ,,,,,090,757 investment 250,000 Minus other payment 250,000 Budgeted ending cash balance 250,,,,,,078,234 Net cash flow ,,,,,563 Interest rate 8% Term in years 5 Principal borrowed 50,000 Ending loan balance 50,,,,, Pro Forma Cash Flow Stmt Name Your Company Pro Forma Cash Flow Statement For the Five Years Enter figures from the other budget schedules. The orange cells include formulas that will populate as data is entered in other cells. Year 0 is the start of the project where funding and startup cost spending occurs before the grand opening. Year Year Walter A Corrigan: Walter A Corrigan: Your first year is either 2016 or 2017. Beginning Cash Balance $0 Walter A Corrigan: Walter A Corrigan: Year 0 beginning cash is $0. Any cash borrowed will show up in the ending cash balance as year 0 net cash financing minus cash disbursements. $0 $0 $0 $0 $0 Add: Collections Walter A Corrigan: Walter A Corrigan: Enter collections from sales. Add: Other cash receipts Total Cash Receipts $0 $0 $0 $0 $0 $0 Total Cash Available for Use $0 $0 $0 $0 $0 $0 Less: Cash Disbursements Walter A Corrigan: Walter A Corrigan: Enter expenses as positive amounts from the income statement that affect cash. Depreciation and TCE route purchase amortization do not affect cash. Cost of sales Salary expenses Payroll expenses Outside services Supplies (office and operating) Repairs and maintenance Advertising Car, delivery and travel Accounting and legal Rent Telephone Utilities Insurance Taxes (real estate, etc.) Other cash disbursements (name it) Other cash disbursements (name it) Other cash disbursements (name it) Other cash disbursements (name it) Startup expenses Initial inventory The Cutting Edge route cost Capital expenditures Total Disbursements $0 $0 $0 $0 $0 $0 Cash Surplus/(Deficit) $0 $0 $0 $0 $0 $0 Financing: Owner investment/(distribution) Borrowing $0 $0 $0 $0 $0 $0 Interest payment (minus $) $0 $0 $0 $0 $0 $0 Principal payment (minus $) $0 $0 $0 $0 $0 $0 Net Cash from Financing $0 $0 $0 $0 $0 $0 Budgeted Ending Cash Balance $0 $0 $0 $0 $0 $0 Net Cash Flow Walter A Corrigan: Walter A Corrigan: Project net cash flows include operating cash flows and investing cash flows but not financing cash flows. The net cash flows can be used to calculate your investment metrics such as NPV, IRR, profitability index and payback. $0 $0 $0 $0 $0 $0 Business Loan Interest rate (research the rate) 8.0% Term in years 5 Walter A Corrigan: Walter A Corrigan: Leave this at 5 years. Principal borrowed Walter A Corrigan: Walter A Corrigan: Enter amount borrowed. The loan amount should be sufficient to cover Section 3.0 CapEx, start-up expenses before the grand opening, an initial inventory if applicable, and probably a contingency fund in the checking account. I would not borrow funds after year 0. If additional external financing is needed enter an owner investment on row 40 in one or more years 0 - 5. You can also show an owner investment repayment by entering a minus amount. Walter A Corrigan: Leave this at 5 years. Walter A Corrigan: The interest should be entered on the income statement as interest expense. Walter A Corrigan: Enter collections from sales. Walter A Corrigan: Enter expenses as positive amounts from the income statement that affect cash. Depreciation and TCE route purchase amortization do not affect cash. Walter A Corrigan: Your first year is either 2016 or 2017. Walter A Corrigan: I would not borrow funds after year 0. If additional external financing is needed enter an owner investment on row 40 in one or more years 0 - 5. You can also show an owner investment repayment by entering a minus amount. WalterC: Year 0 loan payment: No payment in year 0 which is the day the money is borrowed. The first P&I payment is in year 1. WalterC: Beg Cash Bal: You have written over the cell pointer. The Year 1 beginning cash balance is the same as the Year 0 ending cash balance, and so forth for each year. WalterC: Capital Expenditures/Other Year 0 Cash Disbursements: Enter separate lines for Year 0 cash disbursements as positive numbers for spending on CapEx, startup expenses, and any opening inventory (if needed). The startup expenses should be new business expenses and necessary operating expenses for perhaps 4 – 8 weeks before the grand opening. Sheet2 Year Year Year Beginning balance ,,,,,194 Add sales ,,,,,478 Cash available to use ,,,,122,,342,672 Less disbursements ,,,,,915 Cash surplus ,,,,,090,757 investment 250,000 Minus other payment 250,000 Budgeted ending cash balance 250,,,,,,078,234 Net cash flow ,,,,,563 Interest rate 8% Term in years 5 Principal borrowed 50,000 Ending loan balance 50,,,,, Pro Forma Cash Flow Stmt Name Your Company Pro Forma Cash Flow Statement For the Five Years Enter figures from the other budget schedules. The orange cells include formulas that will populate as data is entered in other cells. Year 0 is the start of the project where funding and startup cost spending occurs before the grand opening. Year Year Walter A Corrigan: Walter A Corrigan: Your first year is either 2016 or 2017. Beginning Cash Balance $0 Walter A Corrigan: Walter A Corrigan: Year 0 beginning cash is $0. Any cash borrowed will show up in the ending cash balance as year 0 net cash financing minus cash disbursements. $0 $0 $0 $0 $0 Add: Collections Walter A Corrigan: Walter A Corrigan: Enter collections from sales. Add: Other cash receipts Total Cash Receipts $0 $0 $0 $0 $0 $0 Total Cash Available for Use $0 $0 $0 $0 $0 $0 Less: Cash Disbursements Walter A Corrigan: Walter A Corrigan: Enter expenses as positive amounts from the income statement that affect cash. Depreciation and TCE route purchase amortization do not affect cash. Cost of sales Salary expenses Payroll expenses Outside services Supplies (office and operating) Repairs and maintenance Advertising Car, delivery and travel Accounting and legal Rent Telephone Utilities Insurance Taxes (real estate, etc.) Other cash disbursements (name it) Other cash disbursements (name it) Other cash disbursements (name it) Other cash disbursements (name it) Startup expenses Initial inventory The Cutting Edge route cost Capital expenditures Total Disbursements $0 $0 $0 $0 $0 $0 Cash Surplus/(Deficit) $0 $0 $0 $0 $0 $0 Financing: Owner investment/(distribution) Borrowing $0 $0 $0 $0 $0 $0 Interest payment (minus $) $0 $0 $0 $0 $0