Question

Please use Excel to answer the following TVM questions. You can use this spreadsheet to set up your calculations if you so desire. Unless indicated otherwise, assume that all of the problems are ordinary annuities (payment made at the end of the period). |

Part 3 |
I am going to buy a car. I will finance the whole purchase (no down payment) with a new car loan that has a 6-year term. My monthly payments will be $392/mth and the annual interest rate on the car loan is 6.5%. How much am I buying the car for? | ||||||||

Present Value (PV) = | |||||||||

Future Value (FV) = | |||||||||

Payment (PMT) = | |||||||||

Payments or periods per yr (P/YR) = | |||||||||

Annual Interest Rate (RATE) = | |||||||||

Number of periods (NPER) = |

Answer #1

Please use Excel
to answer the following TVM questions. You can use this spreadsheet
to set up your calculations if you so desire. Unless indicated
otherwise, assume that all of the problems are ordinary annuities
(payment made at the end of the
period).
Part 4 I need $1,000,000 in 20 years if I am going to retire
(Fat Chance!!) I currently have $100,000 saved for my retirement (I
wish!!). A slick Wallstreet investment expert with the last name of
Madoff...

Please use Excel
to answer the following TVM questions. You can use this spreadsheet
to set up your calculations if you so desire. Unless indicated
otherwise, assume that all of the problems are ordinary annuities
(payment made at the end of the
period).
Part 5 A company is going to issue debt in the form of bonds.
The bonds will pay $50 every 6 months to the bond investor. The
bonds have a 10 year term and when the bonds...

The attached printout of an Excel spreadsheet shows the use of
six financial formulas related to the time-value-of-money concepts
discussed in Chapter 5. Your task is to reproduce the spreadsheet
using Excel financial formulas in the red cells, which have the
names shown in blue in the adjacent cells. You can find the
financial formulas in Excel by clicking on Formulas at the top of
the spreadsheet, and then clicking on Financial.
You will submit your spreadsheet through D2L, and...

***Can someone show me how to do this in excel please***
1.
Wesson Metals has an outstanding loan that calls for equal annual
payments of $9,768.46 over the life of the loan. The original loan
amount was $50,000 at an APR of 8.5 percent. How much of the FIRST
loan payment is interest (what is the interest component of the
first annual payment)?
NPER
A.
$3,525.61
RATE
B.
$3,780.93
PV
C.
$4,250.00
PMT
D.
$5,409.16
FV
E.
$5,987.53

You are required to use a financial calculator or spreadsheet
(Excel) to solve 10 problems (provided on page 5) on the
applications of the time value of money. You are required to show
the following four steps for each problem (sample problems and
solutions are provided for guidance): (i) Develop a timeline
(linear representation of the timing of cash flows). (ii) Identify
the time value of money variable (PV, FV, PMT, N, or I/YR) that
needs to be solved/calculated in...

I was looking at the solution to the following question on this
site. I could not understand why use 12 when working out the NPER.
Since the monthly payments start 1 month after should you not use
11?
Question 3. (a) A family member is thinking about
funding his granddaughter’s university education in 8 years when
she is expected to enrol at UWI, St. Augustine. He opens a special
savings account, where he can receive a lump sum in 8...

TVM Assignment
Please answer the question in an excel spreadsheet with
the formulas showing.
Part VI: Car Loan
You are looking to buy a 2018 Ford Focus Titanium Hatchback with
sunroof and leather seats at a price of $26,000. Being a college
student, you have cash to pay taxes, title, license and fees but
your parents offer to give you 10% of the price, $2,600, as a down
payment and you need to finance the remainder of $23,400. You
smartly...

In
your answers, you should properly show your work by writing down
your entries into the calculator. For instance, if you use the TVM
worksheet of your financial calculator to compute how long it takes
to double your account balance given 5% annual interest rate, you
should write down your entries as: I/Y=5, PV=-1, PMT=0, FV=2, CPT
N=? --- the question mark here stands for your answer to the
question.
Question 6 – PV, Ordinary Annuity, Compounding [2 points]:
Find...

Include the values you enter on the TVM Solver with your
solutions. 1. Mr. Wong takes out a $180 000 mortgage to purchase a
new house. The interest rate is 6.4% /a, compounded semi-annually.
He makes monthly payments of $1200.00.
a) How long will it take to pay off the mortgage? N= I%= PV=
PMT= FV= P/Y= C/Y=
b) How much interest is paid over the life of the mortgage?

Time Value of
Money
The following
situations test your comprehension of time value of money concepts.
You will need your financial calculator. For each problem write the
variable from the problem next to the variable in your calculator
menu. Put a question mark next to the variable we are solving for,
and put the answer to that variable on the “Answer” line. Remember
that there has to be a negative number in your calculations for the
formulas to work. If...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 10 minutes ago

asked 27 minutes ago

asked 42 minutes ago

asked 48 minutes ago

asked 58 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago