I need help in creating a financial plan for a small coffee shop.

Appendix 3: New Fair Trade Shade Grown Coffee Project Estimates
These are estimates
Cost of Roaster	$ 21,000
Camila expects to depreciate straight line (see Appendix 2) but you can make a different recommendation if you choose.
Revenue projections
Expected quantity sold	9,000	year 1
Retail price	$ 10.50
Variable costs:
Cost of unroasted beans	$ 4.50	per 12 oz bag
Cost of roasting	$ 3.00	per 12 oz bag
Total variable costs	$ 7.50	per 12 oz bag
Fixed costs year 1	$ 18,000.00	Camila is very uncertain of fixed costs, but knows there will probably be some.
Net Working Capital	only inventory
Camila estimates she needs one month of inventory of beans and coffee bags
Inventory	8%	of variable costs the following year
When the project is terminated in year 5, expect to recover the full amount of Net Working Capital in year 5.
Camila is very unsure of growth but Jeffrey thinks the fair trade coffee sales will growth quickly.
Growth estimates	based on year 1 sales
Expected quantity growth	4%	per year
Growth in variable costs	2%	per year
Growth in fixed costs	4%	per year
Time frame of project	5	years	as Camila believes the roaster will last for at least 5 years
The roaster is expected to have zero value in 5 years.
Required rate
Tax rate	21%
	2021	2022	2023	2024	2025	2026
Year	0	1	2	3	4	5
Forecasted Quantity
Forecasted Revenue
Forecasted Variable Costs
	0	1	2	3	4	5
Net Working Capital
Net Working Capital Balance
NWC Cash flow
Recovery
Cash flows NWC
Equipment Cash Flows
	0	1	2	3	4	5
Revenues
Variable Costs
Fixed Costs
Depreciation
EBIT
Taxes
Depreciation
Operating Cash Flow
Free Cash Flow
Net Present Value
IRR
* You can do the spreadsheet differently if you choose.