Please use the attached spreadsheet to help Corvallis Landscaping, LLC$,$ create a cash flow forecast for the year.$$ Input the items below into the $12$ month spreadsheet to find out if the company will have cash flow problems in the near future.$$The goals for the company and the general nature of the business are as follows:$$

The owner would like to buy a wireless lap top computer next November. The estimate is that it will cost about $$3,500$ for all of the hardware and software.

The owner would like to draw $$15,000$ a year to supplement other household income. A $$1,000$ per month would be sufficient except for June and September when he$$d like $$1500$ per month.$$ In July and August he needs $$2000$ per month.

The owner forecasts total sales of $$100,000$ for the year. Of this, $$6,000$ is on an account which pays $$500$ per month. The estimated sales figures for the year are: Jan $$5,000,$ Feb and March $$5,300,$ April $$5,700,$ May $$7,000,$ June $$11,000,$ July $$15,200,$ August $$14,000,$ Sept $$9,000,$ Oct $$6,000,$ Nov $$5,000$ and Dec $$5,500.$

The owner also estimates the following purchases for the year: Jan and Feb $$1,500$ each month, Mar $$2,500,$ April $$4,500,$ May and June $$9,000$ each month, July $$6,000,$ August $$3,500,$ Sept $$2,000,$ Oct and Nov and Dec $$1,500$ each.

The owner has $$500$ in the checking account, as of today, January $1.$

The owner hires one employee who works all year. The employees$$ gross wages are $$1,275$ per month for Jan, Feb, March, April May, Sept, Oct, Nov and December.$$ Gross wages are estimated to increase to $$1,690$ in June, July, and August.

$$200$ worth of matching employer payroll taxes is paid Jan $15$th$,$ April $15$th$,$ July $15$th$,$ and Oct $15$th$.$

The business pays $$500$ a month in rent. In April, he is expecting a rent increase of $$100$ for a total monthly cost of $$600.$

Supplies cost him $$100$ a month during Jan, Feb, Mar, and April. You anticipate supplies increasing to $$150$ a month during May, Jun, July, and Aug.$$ Supplies then fall back to $$100$ a month for the rest of the year.

Repairs average $$125$ each month, except for Jan, Feb and December when they average $$150.$

Advertising is only $$25$ a month for Jan, Feb, Mar, April, Oct and Nov. In May and June it jumps to $$250$ a month. July and August it$$s $$150$ a month.$$ Sept and Dec it$$s $$50$ a month.

Professional services are $$50$ per month, except for March when they are $$600.$

Telephone and Utilities average $$300$ per month.

$$475$ worth of Worker$$s Comp insurance is paid quarterly $($same as payroll taxes$)$

The owner needs to pay $$personal$$ property taxes of $$750$ in November.

Miscellaneous costs of $$100$ happen in Jan, Feb, Mar and April. It climbs to $$150$ in May, $$200$ in June, July, Aug.$$ It falls to $$150$ in Sept and $$100$ in Oct, Nov and Dec. $\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|\}$

$\backslash$hline $\backslash$multicolumn$\{15\}\{|$c$|\}\{$Corvallis Landscaping, LLC$\}\backslash \backslash$

$\backslash$hline & January & February & March & April & May & June & July & August & September & October & November & December & Total & $\backslash \backslash$

$\backslash$hline Cash at Start of Month & & $0$ & $0$ & $0$ & $0$ & $0$ & $0$ & $0$ & $0$ & $0$ & $0$ & $0$ & & $\backslash \backslash$

$\backslash$hline & & & & & & & & & & & & & & $\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{15\}\{|$l$|\}\{$Cash Income:$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{15\}\{|$l$|\}\{$Sales$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{15\}\{|$l$|\}\{$A$/$R collections$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{15\}\{|$l$|\}\{$Loans$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{15\}\{|$l$|\}\{$Other$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{15\}\{|$l$|\}\{\backslash$multirow$[$t$]\{3\}\{*\}\{\}\}\backslash \backslash$

$\backslash$hline & & & & & & & & & & & & & & $\backslash \backslash$

$\backslash$hline & & & & & & & & & & & & & & $\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{15\}\{|$l$|\}\{$Cash Payments$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{15\}\{|$l$|\}\{$Purchases$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{15\}\{|$l$|\}\{$Payroll$,$ PR Tax,$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{15\}\{|$l$|\}\{$Rent$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{15\}\{|$l$|\}\{$Supplies$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{15\}\{|$l$|\}\{$Repairs and Main$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{15\}\{|$l$|\}\{$Advertising$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{15\}\{|$l$|\}\{$Profess$.$ Services$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{15\}\{|$l$|\}\{$Telephone and Utilities$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{15\}\{|$l$|\}\{$W$/$C Insurance$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{15\}\{|$l$|\}\{$Taxes$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{15\}\{|$l$|\}\{$Interest$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{15\}\{|$l$|\}\{$Miscellaneous$\}\backslash \backslash$

$\backslash$hline & & & & & & & & & & & & & & $\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{15\}\{|$l$|\}\{$Other:$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{15\}\{|$l$|\}\{$Loan Princ Paymts$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{15\}\{|$l$|\}\{$Capital Purchases$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{15\}\{|$l$|\}\{$Withdrawals$\}\backslash \backslash$

$\backslash$hline & & & & & & & & & & & & & & $\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{15\}\{|$l$|\}\{$Tratal ranh Davmanta$\}\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$