I need to create the Pro Forma Cash Flow Statement for my course project, I was given a template to use to create it but I'm lost. I've uploaded my course project thus far as well as the template I was given. The template doesn't necessarily need to be used, I was told, so long as the information is correct for the pro forma cash flows.This is in regards to a landscaping company, and can provide any other needed information.

BUSN278 Budgeting and Forecasting Template Instructions Use this spreadsheet structure to lay out the various sections of your project. The purpose of this spreadsheet is to make it easy for your professor to locate the various sections of your project. Please don't alter the worksheet tabs or titles. After you finish your calculations in this spreadsheet, you will have to create a written report where you take screenshots from this spreadsheet and put them in the Budget Proposal Template, along with necessary explanations. Detailed instructions for how to write the report are found in the Budget Proposal Template, a Word document. Put your sales forecasting calculations here. Per MonthIrrigation Per Other Serv. $ 150.00 $ 50.00 $ 200.00 (150*12)+50+200 = Charges Formula % of pop. Over 110,000 household income within: Miami-Dade County Zip Code 33133 18.81 31.77 South Miami Avg Houshold Income Households 2000 123,846 Zip 33133 Miami All of Florida 3 year change 1.38% 1.78% http://www.deptofnumbers.com/income/florida/miami/ All Cust Num of Cust 2,050.00 $ 205,000.00 100 $ 213,200.00 104 $ 221,728.00 108 $ 230,597.12 112 $ 239,821.00 117 Year 1 2 3 4 5 Avg house cost Customer growth estimated at +0.01 of each previous year 670086 Customer growth estimated increase at +0.03 due to advertising and referrals http://www.city-data.com/income/income-Miami-Florida.html http://www.trulia.com/for_sale/33133_zip/ 1 year change 1.56% 1.44% Per Cust $ Equipment ITEM Pickup Truck Trailer Large Riding Lawnmower Small Riding Lawnmower Push Lawnmower Gas Lawn-Trimmer/Edger Gas Blower Tree Pruner Hedge Trimmer Large Equipment Purchases Branch Cuters Long Ladder Tools for Minor Repair Saftey Equipment Handheld Radio Gas Canister Drink Cooler Regular Equipment Purchases Office/Headquarters 400 sqft Office w/ Utilities Internet/Phone Laptop Computer Software Office Supplies OFFICE TOTAL Labor 8 Workers 2 Supervisors Workers Comp Advertising Owners Salary Business Insurance Health Care Registar as LLC Labor Total TOTAL * assumptions NUM 2 2 1 1 2 3 4 2 2 X X X X X X X X X X X X X X X X MEMO BUYING PRICE Ford F-150 Slightly Used $ 72,000.00 Element 7x16ft $ 8,398.00 ARIENS 52in Kohler 7000 Series $ 3,599.00 ZOOM 42in Kohler 7000 Series $ 2,499.00 POULAN 21in Kohler 675OHV $ 358.00 TORO 2-Cycle 25.4cc Attachmen $ 761.91 ECHO 158mph 375 CFM Gas Bl $ 996.00 FISKARS 14ft. Bypass Pruner $ 79.94 RYOBI 22in. 26cc Gas Hedge Tr $ 358.00 $ FISKARS ByPass Lopper; FISKA$ WERNER 16ft Fiberglass Strai $ COMMERICAL ELECTRIC 22-Pie $ FIRM GRIP Work Gloves/Prote $ UNIDEN 16 Mile/22 Channel $ BRIGGS&STRATTON 5gal Gas $ RUBBERMAID 10gal $ $ TOTAL $ 4 2 2 10 5 2 2 2,500/mo 109/mo Vostro 15 3000 Series w/ Wind Intuit Quickbooks Essentials @ MONTHLY 510 600 158.3 100 8.50/hr 10.00/hr 1,900 Yr 1 275 $ $ $ $ $ $ MEMO $ $ $ $ $ $ $ $ $ $ YEAR LIFE* 10 8 6 6 5 5 5 5 6 89,049.85 263.64 396.76 139.94 223.30 142.55 37.96 89.74 1,293.89 90,343.74 YEAR 1 30,000.00 1,308.00 499.00 258.72 500.00 32,565.72 YEAR 1 6,120.00 7,200.00 1,900.00 1,200.00 42,000.00 1,000.00 3,300.00 160.00 62,880.00 185,789.46 RESIDUAL VALUE* $ 7,000.00 $ 900.00 $ 500.00 $ 500.00 $ 14.32 $ 30.48 $ 39.84 $ $ 14.32 8,998.96 $ - 258.72 500.00 32,066.72 YEAR 3 6,242.40 7,344.00 1,900.00 1,200.00 42,000.00 1,000.00 3,300.00 ### ### 32,066.72 YEAR 4 6,303.60 7,416.00 1,900.00 1,200.00 ### ### 3,300.00 $ $ $ $ $ $ $ Depreciation $ 6,500.00 $ 937.25 $ 516.50 $ 333.17 $ 68.74 $ 146.29 $ 191.23 $ 15.99 $ 57.28 YEAR 4 ### $ 1,308.00 $ YEAR 3 30,000.00 1,308.00 $ YEAR 2 $ YEAR 1 72,000.00 8,398.00 3,599.00 2,499.00 358.00 761.91 996.00 79.94 358.00 $ $ $ $ $ $ $ $ 3-5 3-5 3-5 3-5 3-5 3-5 3-5 $ $ $ $ $ $ $ $ $ $ ### ### 32,066.72 YEAR 2 6,181.20 7,272.00 1,900.00 1,200.00 ### ### 3,300.00 $ $ $ $ $ $ $ $ $ $ 62,853.20 $ 94,919.92 $ $ $ $ $ $ $ 62,986.40 $ 95,053.12 $ 89,049.85 $ 8,766.44 $ YEAR 5 ### $ 30,000.00 1,308.00 $ 1,308.00 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 258.72 500.00 32,066.72 YEAR 5 6,364.80 7,488.00 1,900.00 1,200.00 42,000.00 1,000.00 3,300.00 63,119.60 $ 95,186.32 $ 63,252.80 95,319.52 YEAR 2 65,500.00 7,460.75 3,082.50 2,165.83 289.26 615.62 804.77 63.95 300.72 $ $ $ $ $ $ $ $ $ 80,283.41 $ YEAR 3 59,000.00 6,523.50 2,566.00 1,832.67 220.53 469.34 613.54 47.96 243.44 $ $ $ $ $ $ $ $ $ 71,516.97 $ YEAR 4 52,500.00 5,586.25 2,049.50 1,499.50 151.79 323.05 422.30 31.98 186.16 $ $ $ $ $ $ $ $ $ YEAR 5 46,000.00 4,649.00 1,533.00 1,166.33 83.06 176.76 231.07 15.99 128.88 62,750.53 $ 53,984.09 YEAR ONE Incoming Cash Loan Sales Total Incoming CASH BALANCE Outgoing Cash Labor Total Office Total Equipment Total Equipment Depreciation OUTGOING TOTAL Surplus/Defict 190,000.00 205,000.00 $ 395,000.00 $ 395,000.00 $ $ $ $ $ 62,880.00 $ 32,565.72 $ 90,343.74 $ 185,789.46 $ $ Financing Loan Repayment Cost of Route Purchase TOTAL OUT ENDING CASH BALANCE $ $ $ $ $ $ $ $ YEAR TWO YEAR THREE YEAR FOUR YEAR FIVE 213,200.00 $ 213,200.00 $ 213,200.00 $ 221,728.00 $ 221,728.00 $ 221,728.00 $ 230,597.12 $ 230,597.12 $ 230,597.12 $ 239,821.00 239,821.00 239,821.00 62,853.20 $ 32,066.72 $ 62,986.40 $ 32,066.72 $ 63,119.60 $ 32,066.72 $ 63,252.80 32,066.72 8,766.44 $ 103,686.36 $ 8,766.44 $ 103,819.56 $ 8,766.44 $ 103,952.76 $ 8,766.44 104,085.96 209,210.54 $ 109,513.64 $ 117,908.44 $ 126,644.36 $ 135,735.05 31,350.00 $ 120,000.00 337,139.46 $ 57,860.54 $ 31,350.00 $ 31,350.00 $ 31,350.00 $ 31,350.00 135,036.36 $ 78,163.64 $ 135,169.56 $ 86,558.44 $ 135,302.76 $ 95,294.36 $ 135,435.96 104,385.05 Total $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 190,000.00 1,110,346.12 1,300,346.12 1,300,346.12 315,092.00 160,832.60 90,343.74 35,065.76 601,334.10 699,012.03 156,750.00 120,000.00 878,084.10 422,262.03 Avg Cash Inflow $ 84,452.41 Cash Inflows 10% Discount Factor Present Value $ $ YEAR 1 57,860.54 $ 0.90909 52,600.44 $ YEAR 2 78,163.64 $ 0.82645 64,598.34 $ YEAR 3 86,558.44 $ 0.75131 65,032.22 $ YEAR 4 95,294.36 $ 0.68301 65,087.00 $ YEAR 5 104,385.05 0.62092 64,814.76 TOTAL INFLOW $ PRESENT VALUE INITIAL INVESTMENT NET PRESENT VALUE $ $ $ 312,132.76 190,000.00 122,132.76 TOTAL PV 422,262.03 $ 312,132.76 Initial Investment Annual Cash Inflows IRR $ $ 190,000.00 422,262.03 45% annnual depreciation Avg Cash Inflow Avg Accounting Income ARR $ $ $ 6,966.65 84,452.41 77,485.76 41% YEAR $ 1 2 3 4 5 Payback Period INVESTMENT 190,000.00 ANNUAL CASH FLOW $ $ $ $ $ 57,860.54 78,163.64 86,558.44 95,294.36 104,385.05 CUMULATIVE CASH FLOW $ $ $ $ $ 57,860.54 136,024.18 222,582.62 317,876.98 422,262.03 2.62 Years Pro Forma Income Statement REVENUE Initial Investment Sales Total COST Salary Wages Worker Compesation Owner Healthcare Business Insurance LLC Filing Fees Depreciation Rent Utilites Advertising Office Equipment Start-Up Expenses (Equipment) TOTAL COST Profit Before Tax Taxes (25%) After Tax 4% Profit NET INCOME YEAR ONE YEAR TWO YEAR THREE YEAR FOUR YEAR FIVE $ 190,000.00 $ 205,000.00 $ 213,200.00 $ 221,728.00 $ 230,597.12 $ 239,821.00 $ 205,000.00 $ 213,200.00 $ 221,728.00 $ 230,597.12 $ 239,821.00 $ 42,000.00 $ 42,000.00 $ 42,000.00 $ 42,000.00 $ 42,000.00 $ 13,320.00 $ 13,453.20 $ 13,586.40 $ 13,719.60 $ 13,852.80 $ 1,900.00 $ 1,900.00 $ 1,900.00 $ 1,900.00 $ 1,900.00 $ 3,300.00 $ 3,300.00 $ 3,300.00 $ 3,300.00 $ 3,300.00 $ 1,000.00 $ 1,000.00 $ 1,000.00 $ 1,000.00 $ 1,000.00 $ 160.00 $ 8,766.44 $ 8,766.44 $ 8,766.44 $ 8,766.44 $ 8,766.44 $ 30,000.00 $ 30,000.00 $ 30,000.00 $ 30,000.00 $ 30,000.00 $ 1,308.00 $ 1,308.00 $ 1,308.00 $ 1,308.00 $ 1,308.00 $ 1,200.00 $ 1,200.00 $ 1,200.00 $ 1,200.00 $ 1,200.00 $ 1,257.72 $ 758.72 $ 758.72 $ 758.72 $ 758.72 $ 90,343.74 $ 194,555.90 $ 103,686.36 $ 103,819.56 $ 103,952.76 $ 104,085.96 $ 10,444.10 $ 109,513.64 $ 117,908.44 $ 126,644.36 $ 135,735.05 $ 2,611.03 $ 27,378.41 $ 29,477.11 $ 31,661.09 $ 33,933.76 $ 7,833.08 $ 82,135.23 $ 88,431.33 $ 94,983.27 $ 101,801.28 $ 313.32 $ 3,285.41 $ 3,537.25 $ 3,799.33 $ 4,072.05 $ 7,519.75 $ 78,849.82 $ 84,894.08 $ 91,183.94 $ 97,729.23 Pro Forma Balance Sheet ASSETS Accumulated Depreciation (Assets-Depreciation) Cash Other Current assets Total Assets LIABILITIES Current liabilities Non-current liabilities Loan Equity Retained Earnings $ $ $ $ 90,343.74 8,766.44 81,577.30 57,860.54 $ 90,343.74 $ 17,532.88 $ 72,810.86 $ 78,163.64 $ 18,219.06 $ 139,437.84 $ 169,193.56 $ 41,574.35 $ 90,343.74 $ $ 90,343.74 $ 26,299.32 $ 64,044.42 $ 86,558.44 $ 24,634.95 $ 175,237.82 90,343.74 $ $ 90,343.74 $ 35,065.76 $ 55,277.98 $ 95,294.36 $ 30,955.34 $ 181,527.68 90,343.74 $ $ 90,343.74 $ 43,832.20 $ 46,511.54 $ 104,385.05 $ 37,176.38 $ 188,072.97 90,343.74 $ 90,343.74 $ 7,519.75 $ 78,849.82 $ 84,894.08 $ 91,183.94 $ 97,729.23 $ 139,437.84 $ 169,193.56 $ 175,237.82 $ 181,527.68 $ 188,072.97 Name Your Company Pro Forma Cash Flow Statement For the Five Years 2016 - 2020 Enter figures from the other budget schedules. The orange cells include formulas. Year 0 is the start of the project where funding and startup cost spending occurs before the grand opening. Year Beginning Cash Balance Add: Collections Add: Other cash receipts Total Cash Receipts Total Cash Available for Use Year 0 2016 2017 2018 2019 2020 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Less: Cash Disbursements 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 expenses (specify) Other expenses (specify) Other expenses (specify) Other expenses (specify) Other expenses (specify) Other expenses (specify) Capital expenditures Total Disbursements $0 $0 $0 $0 $0 $0 Cash Surplus/(Deficit) $0 $0 $0 $0 $0 $0 Financing: Owner investment/(distribution) Borrowing Interest payment (minus $) Principal payment (minus $) Net Cash from Financing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Budgeted Ending Cash Balance $0 $0 $0 $0 $0 $0 Net Cash Flow $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Business Loan Interest rate (research the rate) Term in years Principal borrowed Interest payment (minus $) Principal payment (minus $) Ending Loan Balance 8.0% 5 $0 $0 $0 The Excel Five Year Pro Forma Cash Flow Statement was developed using a template authored by Irfanullah Jan and retrieved on October 5, 2015 from: http://accountingexplained.com/managerial/master-budget/cashbudget