Year 1	Year 2	Year 3	Year 4	Year 5
	Annual Interest		$6,730.50
Loan Payment Calculation			Months	Payment	Principal	Interest	Begin. Balance	Ending Balance
Loan Amount	$ 150,000.00		1	$2,823.06	$2,211.94	$611.12	150,000	$147,788.06
Interest rate ( Yearly)	5%		2	$2,823.06	$2,220.95	$602.11
Term( Years)	5		3	$2,823.06	$2,230.00	$593.06
			4	$2,823.06	$2,239.09	$583.97
Monthly Interest rate	0.004074124		5	$2,823.06	$2,248.21	$574.85
Monthly Payment	$2,823.06		6	$2,823.06	$2,257.37	$565.69
			7	$2,823.06	$2,266.57	$556.49
			8	$2,823.06	$2,275.80	$547.26
			9	$2,823.06	$2,285.07	$537.99
			10	$2,823.06	$2,294.38	$528.68
			11	$2,823.06	$2,303.73	$519.33
			12	$2,823.06	$2,313.11	$509.95
			13	$2,823.06	$2,322.54	$500.52
			14	$2,823.06	$2,332.00	$491.06
			15	$2,823.06	$2,341.50	$481.56
			16	$2,823.06	$2,351.04	$472.02
			17	$2,823.06	$2,360.62	$462.44
			18	$2,823.06	$2,370.24	$452.82
			19	$2,823.06	$2,379.89	$443.17
			20	$2,823.06	$2,389.59	$433.47
			21	$2,823.06	$2,399.32	$423.73
			22	$2,823.06	$2,409.10	$413.96
			23	$2,823.06	$2,418.92	$404.14
			24	$2,823.06	$2,428.77	$394.29
			25	$2,823.06	$2,438.67	$384.39
			26	$2,823.06	$2,448.60	$374.46
			27	$2,823.06	$2,458.58	$364.48
			28	$2,823.06	$2,468.59	$354.47
			29	$2,823.06	$2,478.65	$344.41
			30	$2,823.06	$2,488.75	$334.31
			31	$2,823.06	$2,498.89	$324.17
			32	$2,823.06	$2,509.07	$313.99
			33	$2,823.06	$2,519.29	$303.77
			34	$2,823.06	$2,529.56	$293.50
			35	$2,823.06	$2,539.86	$283.20
			36	$2,823.06	$2,550.21	$272.85
			37	$2,823.06	$2,560.60	$262.46
			38	$2,823.06	$2,571.03	$252.03
			39	$2,823.06	$2,581.51	$241.55
			40	$2,823.06	$2,592.02	$231.04
			41	$2,823.06	$2,602.58	$220.48
			42	$2,823.06	$2,613.19	$209.87
			43	$2,823.06	$2,623.83	$199.23
			44	$2,823.06	$2,634.52	$188.54
			45	$2,823.06	$2,645.26	$177.80
			46	$2,823.06	$2,656.03	$167.03
			47	$2,823.06	$2,666.85	$156.21
			48	$2,823.06	$2,677.72	$145.34
			49	$2,823.06	$2,688.63	$134.43
			50	$2,823.06	$2,699.58	$123.48
			51	$2,823.06	$2,710.58	$112.48
			52	$2,823.06	$2,721.62	$101.44
			53	$2,823.06	$2,732.71	$90.35
			54	$2,823.06	$2,743.85	$79.21
			55	$2,823.06	$2,755.02	$68.04
			56	$2,823.06	$2,766.25	$56.81
			57	$2,823.06	$2,777.52	$45.54
			58	$2,823.06	$2,788.83	$34.23
			59	$2,823.06	$2,800.20	$22.86
			60	$2,823.06	$2,811.60	$11.45

	Data Table	0%	5%	10%	15%	20%
	Growth Rate
	Income
	Interest Expense
	Drop Down Cell	Poor	OK	Expected	Good	High
	Growth Rate
	Income
	Interest Expense
Tax Rate	35%	35%	35%	35%	35%
Interest Rate	5%	5%	5%	5%	5%
Growth rate	0%	5%	10%	15%	20%

Most important is show me how to do a data valadation and data table in excel set up - explain- MAKE UP THE NUMBERS USING THE ACCOUNTS I PROVIDED- I NEED FINANCIAL STATEMENTS CREATED!!!! I DON'T HAVE ANYMORE INFO SO CREATE IT FROM SCRATCH AS LONG AS IT BALANCES... I WON'T BE PROVIDING MORE THEN I DID IN THE INCOME STATE THAT'S WHY I CLEARLY STATE CREATE FINANCIAL STATEMENTS THAT BALANCE IN EXCEL WHEN INTEGRATED. DON'T SAY INCOMPLETE BECAUSE YOUR WASTING MY QUESTIONS, CREATE THEM FROM WHERE I LEFT OFF IN THE INCOME STATEMENT

Finish the income statement using whatever numbers you need to make sure all three financial statements balance. ( make them up) as long as they balance and can be integrated in excel. Then create and explain the following excel directions in the sense how they were done so I could do it easily again from my end. ( Financial statements need to be for 3 years 2016, 2017, 2018)

Create an Excel Data Table that lists the projected second-year income and interest expense for your firm under five sales growth scenarios, e.g. 0%, 5%, 10%, 15%, or 20% sales growth. [Variable Data Tables, MacDonald] 2) Create a Drop-Down User Input Cell with five choices for the firms growth prospects: Poor, OK, Expected, Good, & High [Data Validation with Lists, MacDonald]. 3) Place Formulas in two nearby output-cells that display the corresponding net income and interest expense amounts listed in the data table from part (a). Use the Excel Lookup Function [MacDonald] with Nested Excel If Statements [ MacDonald] to extract the data from the data table. Use Nested Excel If Statements to translate the user selection from the drop-down input in part (b) to one of the percentage sales growths used to form the data table in part (a), e.g. if the user selects Expected, the if statement returns 10% (0.10). Use the Lookup Function to find and display the net income and interest expense corresponding to the given sales growth in the data table. 4) Generate a Well-Formatted Chart [MacDonald] to display the data listed in the data table from part (a). 5) Use labels and formatting as appropriate to guide the user in using the functionality added in parts (a) (c).

Income Statement	Past Year	Current	Balance Sheet				Statement of Cash Flows			2016	2017
Revenue	2016	2017	Assets		2016	2017	Net Income
Sales Revenue	$ 12,212,000.00		Current Assets				Add Back:
Less: Sales discounts & returns	$ 3,000.00		Cash and Cash Equivalents				Depreciation
Net Sales	$ 12,209,000.00		Accounts Receivable				Change in A/R
Less: Cost of Goods Sold	$ 3,000,000.00		Inventory				Change in Inventory
Gross Margin	$ 9,209,000.00		Prepaid Expenses				Change in A/P
Operating Expenses:			Short term Investments				Change in Accruals
Advertising expense	$ 500,000.00		Total Current Assets				Net Cash from Operations
Office Supplies expense	$ 10,000.00		Fixed Long Term Assets
Salaries expense	$ 499,600.00		Long term investments				Property & Equip. Purchases, net
Rent	$ 44,000.00		Property, Plant, and Equipment				Net Cash - Investing Activities
Insurance	$ 13,000.00		(Le Accumulated depreciation)
Utilities	$ 3,000.00		Intangible assets				Short Term Financing , Net
Fees	$ 3,000.00		Other Assets				Long Term Financing, Net
Maintenance and repairs	$ 10,000.00		Total other assets				Owner's Contribution, Net
Research and Development	$ 50,000.00		Total Assets				Net Cash from Financing Act.
Software	$ 200,000.00		Liabilities and Owner's Equity
Owner wages	$ 300,000.00		Current Liabilities				Net Change in Cash
other	$ 4,000.00		Accounts Payable				Cash, Beginning of Year
web hosting and domains	$ 1,000.00		Notes Payable				Cash, End of Year
Miscellaneous	$ 8,000.00		accrued salaries and wages
Depreciation	$ 10,000.00		unearned revenue
Travel	$ 50,000.00		Total Current Liabilities
commission	$ 800,000.00		Long term debt
Total Operationg Costs	$ 2,505,600.00		Deferred income tax
EBT	$ 6,703,400.00		Total Long term Liabilities
Interest	$ 6,730.50		Owner's Equity
Income before taxes	$ 6,696,669.50		Owner's Investment
Income Tax Expense			Retained earnings
Income from continuing operations	0		Total Equity
Income from discontinued operations			Total Liabilities and Equity
Effect of accounting changes			Distributions to Owners
Extraordinary items			Funds Needed
Net Income