Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

Excel home work urgent

1 answer below »
Documentation
    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 Calculato
    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. A
eviation    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%
        Ne
aska    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
Answered Same Day May 10, 2022

Solution

Rochak answered on May 10 2022
107 Votes
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 Calculato
    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...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here