Excel home work urgentDocumentation Title: Purpose: Author: Creation Date: Last Update: Update...

Question

Excel home work urgentDocumentation 	Title: 	Purpose: 	Author: 	Creation Date: 	Last Update: 	Update Date: 	File Name: 	Table of Contents:	Worksheets:	Named Cells and Ranges: 	Complex Algorithms Used: 	Assumptions Made: 	Testing Performed: Calculations 	Bill & Teds Excellent RV Payment Calculator 	The loan information shown here are estimates only, your actual payment may vary 	Customer Information				Payment Information 		First Name	Last Name 	Customer Name				Cash Due At Signing 	Customer Address				Final Loan Amount 	City				Monthly Payment 	State				Total Cost of Loan 	Zip 	RV Information				Fees and Taxes 	Model				Documentation Fee 	Initial Purchase Price				Sales Tax Rate 	Discount Percentage				Sales Tax 	Discount Amount 	Purchase Price 	Loan Information 	Minimum Down Payment 	Down Payment 	Trade In 	Initial Loan Amount 	Interest Rate 	Loan Term Years 	Roll Documentation & Fee Sales Tax Into Loan Sales Tax Rates 		State and Local Sales Tax Rates as of January 1, 2015 		State	St. Abbreviation	State Tax Rate 		Alabama	AL	4.00% 		Alaska	AK	0% 		Arizona	AZ	5.60% 		Arkansas	AR	6.50% 		California	CA	7.50% 		Colorado	CO	2.90% 		Connecticut	CT	6.35% 		Delaware	DE	0% 		Florida	FL	6.00% 		Georgia	GA	4.00% 		Hawaii	HI	4.00% 		Idaho	ID	6.00% 		Illinois	IL	6.25% 		Indiana	IN	7.00% 		Iowa	IA	6.00% 		Kansas	KS	6.15% 		Kentucky	KY	6.00% 		Louisiana	LA	4.00% 		Maine	ME	5.50% 		Maryland	MD	6.00% 		Massachusetts	MA	6.25% 		Michigan	MI	6.00% 		Minnesota	MN	6.88% 		Mississippi	MS	7.00% 		Missouri	MO	4.23% 		Montana	MT	0% 		Nebraska	NE	5.50% 		Nevada	NV	6.85% 		New Hampshire	NH	0% 		New Jersey	NJ	7.00% 		New Mexico	NM	5.13% 		New York	NY	4.00% 		North Carolina	NC	4.75% 		North Dakota	ND	5.00% 		Ohio	OH	5.75% 		Oklahoma	OK	4.50% 		Oregon	OR	0% 		Pennsylvania	PA	6.00% 		Rhode Island	RI	7.00% 		South Carolina	SC	6.00% 		South Dakota	SD	4.00% 		Tennessee	TN	7.00% 		Texas	TX	6.25% 		Utah	UT	5.95% 		Vermont	VT	6.00% 		Virginia	VA	5.30% 		Washington	WA	6.50% 		West Virginia	WV	6.00% 		Wisconsin	WI	5.00% 		Wyoming	WY	4.00% Models & Prices 		Bill & Teds RV Models 		Model	Price 		RunAbout	$   25,000.00 		Roamer	$   55,000.00 		Born Free	$   62,000.00 		CareFree	$   80,000.00 		LiveFree	$   125,000.00 		Whale	$   250,000.00 		VanFare	$   325,000.00 		TheBus	$   450,000.00 		Land Yacht	$   485,000.00 		BunkHouse	$   500,000.00 		King of the Road	$   560,000.00

Rochak · Accepted Answer

Documentation
	Title:
	Purpose:
	Author:
	Creation Date:
	Last Update:
	Update Date:
	File Name:
	Table of Contents:	Worksheets:	Named Cells and Ranges:
	Documentation	Documentation
	Calculation	Calculations
	Sales Tax Rates	Sales Tax Rates
	Models & Prices	Models & Prices
	Complex Algorithms Used:
	Data Validation	To create a list
	Vlookup	To find specific price and tax rates
	PMT	To calculate the monthly loan payment
	Assumptions Made:
	State	Alabama
	Discount Percentage	2%
	Minimum Down Payment	$20,000.00
	Down Payment	$22,500.00
	Interest Rate	8.00%
	Loan Term Years	10.00
	Documentation Fees	$500.00
	Testing Performed:
Calculations
	Bill & Teds Excellent RV Payment Calculator
	The loan information shown here are estimates only, your actual payment may vary
	Customer Information				Payment Information
		First Name	Last Name
	Customer Name	John 	Smith		Cash Due At Signing	$100,000.

Excel home work urgent

Answer To: Excel home work urgent

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment