excel multi-part question and need the explanation and answer to help me learn.
First, you will create an Amortization Schedule for a new (or used) vehicle of your choice. The second half of this assignment asks you to create a second amortization schedule for a home, land, or commercial building/land you may be interested in.
Part 1: Vehicle Major Purchases
Using MS Excel, create an amortization schedule for a car loan. There is an Amortization schedule attached to this assignment for you to use for this and the Part 2 portion of this exercise. Fill out the schedule with data using a vehicle purchase you research on the Internet. Use a reasonable price from Kelly Blue Book or from an online “build your own” resource. Make sure you complete the Amortization schedule to completely pay off your vehicle.
Answer the following Six questions in some detail at the bottom of the same Excel file (see below). Finally, on the last page of your excel file, answer the following questions:
What is your payment per month?
What is your total paid interest for the term of the loan?
How long is the term for your loan? Why did you choose this term length?
What interest rate did you use AND how did you obtain a legitimate interest rate.
What did you learn from this exercise about incurring debt to purchase this vehicle?
Is this car affordable in your budget at this time?
Part 2: Home, Land, or Commercial Property Major Purchase
Using a second MS Excel spreadsheet, create another amortization schedule for a property you may consider buying some time in the future. Use a reasonable value for the investment by searching with a multiple listing in your area.
Next, find a lender that will talk to you and get an interest rate and loan period that they think would be reasonable for this purchase. Most, if not all, lenders are willing to help with a project like this, so talk to someone you are familiar with and get them to help with a loan period and interest rate. Make sure you complete the Amortization schedule to completely pay off the property.
Finally, on the last page of your excel file, answer the following in some detail:
Describe what property you are wanting to invest in.
What is a reasonable price for the property and what resource did you use to come to that price?
How much do you want to borrow, and how much are you contemplating as an initial investment (down payment) on the property?
Who did you talk to about an interest rate? How long are you financing the purchase for and what interest have you found a lender would give you?
What is your total paid interest for the term of the loan from the Amortization Schedule?
What have you learned from this exercise?
This question has already been tackled by one of our writers and a good grade recorded. You can equally get high grades by simply making your order for this or any other school assignment that you may have.
Every Student Buys Essays from us, here is why!
Pressed for time to complete assignments or when you feel like you cannot write, you can purchase an
essay on our website. Some students also want model papers to use as samples when revising or
writing. There are also students who approach our essay writing service to beat deadlines. We handle
every type of homework, assignment, and academic writing tasks. You can buy college essays and other
assignments here. At a glance, here are some reasons students prefer our website.
100% Original Essays and Papers
You can be sure that you are getting a paper that is custom written based on your instructions. We do
not sell papers that are pre-written. Instead, we write every essay from scratch. When you say “write my
essay,” we respond by giving you a paper that is 100% original and free of any plagiarism. The essays you
purchase from us have never been sold anywhere.
Flexible & Affordable Prices
It does not cost a fortune to get academic writing help on our website. If you have a question from class,
place an order, get a discount, and get cheap essay writing services. What you see as the price is what
you pay for. There are no any hidden charges. If you need urgent papers, they might cost a little more,
but the price is worth the quality you get in the end. Hire a professional academic writer beginning from
$13 a page.
Anonymity, Privacy, and Confidentiality
No one will ever know that you purchased an essay or assignment from our website. The essays you buy
from us are written by experts. Your data is only used to coordinate the essay writing services you get.
No one can access your personal information and data. Go ahead and order an essay from our website.
It is safe, secure, and convenient.