For the years $2022$ through $2027$ please create a simple income statement, balance sheet and cash flow

forecast for a podiatry office, based on the following assumptions. If there are any other assumptions you

need to make, please use your best estimate, and note accordingly.

a$.2021$ Visits: $80/$ week $$ increases at $2\%$ per year

b$.2021$ Rate $/$ Visit: $$120$ increases at $5\%$ per year

c$.$ COGS $10\%$ of revenue

d$.$ Provider compensation

i$.$ $$100$k $/$ year up to $$300$k of revenue, $30\%$ of revenue in excess of $$300$k

ii$.$ Additional $20\%$ fringe

e$.$ Billing costs: $5\%$ of revenue

f$.2021$ Facilities Costs: $$4$k $/$ month $$ increases $3\%$ per year

g$.2021$ Administration Costs $$8$k $/$ month $$ increases $3\%$ per year

h$.$ $$50,000$ debt outstanding, interest rate: $5\%,$ assume no repayment

i$.$ Tax Rate $20\%$

j$.$ Days Receivable Outstanding $45$

k$.$ Inventory Days Outstanding $-30$

l$.2021$ Ending Cash: $$50,000$

m$.2021$ Ending PP&E: $$150,000,$ assume an average $5$ year useful life

n$.$ Capex $-2\%$ of revenue

o$.$ Days Payable Outstanding $30$

p$.$ Maintenance Capex $-3\%$ of revenue

q$.$ Stockholders$$ equity can be a plug in $2021$ to create an opening balance sheet that

balances