Financial planner -- lunch model

Saving...

| cells cell options

| spreadsheet formula options

Financial planner -- lunch model by ramit1

	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

	Number Formatting
		none		1,234 1,234.56 $1,234 $1,234.56		1234 1234.56 25% 25.35%		Currency symbol: Decimal places:

	Row/Column Options
		insert row before insert row after		insert column before insert column after		remove row remove column

	Font Formatting
		B I U		strike a⁺ a^-