| Financial Planner Lunch Model | |||||||||
| Change the value of the inputs in red to see how much profit the financial planner makes per year. | |||||||||
| Variables | INPUTS | ||||||||
| Number of guests she brings to lunch per week | 6 | ||||||||
| % of guests who give her their phone number | .5 50% | ||||||||
| % of guests who then meet with her | .1 10% | ||||||||
| % of guests who then hire her | .1 10% | ||||||||
| Hours per year she works for each guest | 15 | ||||||||
| Amount she charges per hour | 75 | ||||||||
| Cost of lunch per guest | 10 | ||||||||
| Do not type below. | |||||||||
| OUTPUT | |||||||||
| Amount of money she earns per year | 1755.0000000000005 $1,755.00 | ||||||||
| Amount of money she spends per year | 3120 $3,120.00 | ||||||||
| Profit per year | -1364.9999999999995 -$1,364.99 | ||||||||