The balance sheet (not shown in the excel document) as of 12/31/12 shows that Owner Equity was $798,918. If this amount were invested at 3% paid out annually for 40 years, what annual income would the investment produce? (Tip: His investment would be a payment).

The following are options for increasing the return on Mr. Moores retirement income (as calculated in number 5 ): Work a little longer, invest at a higher rate of return, sell the business for more (that is, increase PV), increase the number of years for which the money is invested, wait to become eligible for social security payments T/F

What is the Return on Equity for 2014?

What is the Return on Total Assets for 2014?

In your opinion is this a viable business that Mr. Moore can operate for as long as he wants to? Evaluate the business from 2009 to 2014 in the process of answering this question.

Moores Familay Restaurant Financial Data		2013	2014 (Present Day)	2015 Budget Forecast
Budget Worksgheet
Sales		$1,575,396	$1,696,296	Answer to number 17
Cost of Product		$697,211	$597,211	Answer to number 18
Labor		$330,772	$340,695	Answer to number 19
Benefits		$79,872	$114,519	Answer to number 20
Utilities		$54,340	$50,644	$58,241
Loan Principle Repayments		$0	$0	$0
Insurance & Property Taxes		$110,000	$110,000	$110,000
Services (accounting, trash, cleaning, etc.)		$41,051	$43,908	Answer to number 21
Other: SG&A, advertising, promostions		$77,629	$84,771	$93,248
Total Costs		$1,390,875	$1,341,748	Answer to number 22
Earnings Before Interest, Income Taxes, & Depreciation (EBITD)		$184,521	$354,548	Answer to number 23
Interest on loan		$3,500	$3,000	$3,000
Income Taxes		$51,666	$99,273	#VALUE!
Depreciation on values		$71,176	$61,777	$61,177
Earnings After Interest, Income Taxes, & Depreciation		$58,179	$190,497	#VALUE!
Meals Sold		233,392	242,328	261,714
Average Meal Value		6.75	7.00	7.35

	Moore's Family Restaurant
	Assets & Liabilities as of 12/31/13					Assets & Liabilities projected to 12/31/14
		ASSETS				ASSETS
		Cash	$492,118.00			Cash	$589,118.00
		Accounts Receivable	$29,000.00			Accounts Receivable	$49,095.00
		Inventories	$30,000.00			Inventories	$30,000.00
		Prepaid Expenses	$2,000.00			Prepaid Expenses	$11,000.00
		Total Current Assets	$553,118.00			Total Current Assets	$679,213.00
		Building	$727,460.97			Building	$760,000.00
		Equipment	$14,500.00			Equipment	$18,000.00
		Fixtures	$33,320.00			Fixtures	$35,500.00
		Total Fixed Assets	$775,280.97			Total Fixed Assets	$813,500.00
		Total Assets	$1,328,398.97			Total Assets	$1,492,713.00
		LIABILITIES				LIABILITIES
		Accounts Payable	$57,432.00			Accounts Payable	$137,566.00
		Wages and Benefits Due	$16,516.59			Wages and Benefits Due	$29,543.00
		Estimated Taxes and Fees	$6,013.00			Estimated Taxes and Fees	$8,013.00
		Total Current Liabilities	$79,961.59			Total Current Liabilities	$175,122.00
		Long Term Loan	$70,000.00			Long Term Loan	$70,000.00
		Total Long-Term Liabilities	$70,000.00			Total Long-Term Liabilities	$70,000.00
		Owner Equity	$1,178,437.38			Owner Equity	$1,247,591.00
		Total Liabilities and Owner Equity	$1,328,398.97			Total Liabilities and Owner Equity	$1,492,713.00