Implement a spreadsheet to calculate payments, Financial Accounting

Assignment Help:

Tony is a salesperson at a local auto showroom. He asks you to assist him in developing a tool for calculating purchase and lease payments. He has already developed a draft of the problem but he needs help making it easier to use. Tony has some ideas about what the workbooks should contain. He has one sheet named "Sales Support" which consolidates the various data entry and results needed to price a car under various options. A second sheet, named "Loan Rate Sheet" contains the annual loan rates available from several local banks. A third worksheet, labeled "Do Not Delete" contains information about bank loan rates - it's confidential, so it is hidden and protected from you. Leave it in place as is.  A fourth sheet, "Calculations", is for your use to perform intermediate calculations as you see fit.

He has provided a draft of the workbook, which is available on Blackboard.  The green areas are where you make modifications to the interface. Users of the spreadsheet will not need to change other sections.

Your tasks:

Create a payment calculator on the Sales Support worksheet.   

First, open the draft worksheet and save it as an Excel 2010 workbook (.xlsx) named with your last name.  Enter your name and NetID on the Sales Support worksheet in cells A1 and A2. 

The total vehicle price (Cell B11) is determined from the base price of the vehicle (Cell B5), the total cost of six options selected by the customer (Cell B6), a repeat customer discount (Cell B9), plus applicable taxes (Cell B10).  

o The base price of the vehicle may run from a minimum of $1,000 to a maximum of $30,000. Create a form control scroll bar in cells D5 through F5 to simplify the entry of the base price of the vehicle price.  Use increments of $500.  The cell link of the scrollbar should be cell B5. 

Format cell B5 for currency.

o Create checkboxes for six options: CD changer, Movie Player, Bucket Seats, Air Conditioning, Full size spare tire, and Lifetime Oil changes. Place the checkboxes in range D6:D8 or F6:F8, with the cell links in E6:E8 or G6:G8, respectively. Each selected option adds $200 to the cost of the vehicle.  Put the total option cost in B6, formatted for currency.

o Return customers receive a $200 discount from the price before taxes are calculated. Add a combobox form control to indicate if the customer is a new customer or a returning one.  Store the data you need for the input ranges on the Calculations sheet.  Use Cell E9 for the cell link.


Related Discussions:- Implement a spreadsheet to calculate payments

The time value of money , Calculate the present value and determine the npv...

Calculate the present value and determine the npv, Financial Management. Assume today is 3 December 2009. Helen is 30 years old and has a Bachelor of Business. She is currently em

State the users of accounting information, State the users of accounting in...

State the users of accounting information Environment has brought new challenges for managers and other users of accounting information. Their requirements have changed and bot

Accounting for PPE, Acquisition of Assets: The cost method of accounting is...

Acquisition of Assets: The cost method of accounting is used for the initial recording of all acquisitions of assets controlled by the authority. Cost is determined as the fair val

Evaluating the results of testing, Use of Professional Skepticism when Eval...

Use of Professional Skepticism when Evaluating the Results of Testing - AUDITOR should conduct the audit of internal control over financial reporting and audit of financial stateme

Presumption of survivorship, PRESUMPTION OF SURVIVORSHIP Where two or m...

PRESUMPTION OF SURVIVORSHIP Where two or more persons have died in circumstances rendering it uncertain which of them survived the other or others, the deaths shall, for all pu

Financial information, The enhancing qualitative characteristic of understa...

The enhancing qualitative characteristic of understand ability means that information should be understood by a those who are experts int eh interpretation of financial information

Which is not necessary in order for corporation to pay cash, Q. Which one o...

Q. Which one of the following is not necessary in order for a corporation to pay a cash dividend? a. Adequate cash b. Approval of stockholders c. Declaration of dividends by the bo

Definition of bankruptcy, DEFINITION OF BANKRUPTCY Bankruptcy is another ...

DEFINITION OF BANKRUPTCY Bankruptcy is another key area of accounting . The issues addressed here deal with the properties of an individual (a sole trader or partner in a partner

Estimate the montly sales budget, Your friend Peter is planning to set up a...

Your friend Peter is planning to set up a new business which will manufacture and sell wooden tables. The parts that make up the table consist of a wooden table top measuring 1m by

Seller-buyer-seller’s bank and buyer’s bank, I am facing some problems in ...

I am facing some problems in my assignment of Seller, Buyer, Seller’s Bank, and Buyer’s Bank. Can anybody suggest me the proper explanation for it? a. Draw the diagram of the tr

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd