Question

Please provide a real-life example of what you learned. It can be a present value, future value, number of periods, interest rate (growth rate), or payment problem. You need to state the problem and then solve the problem. The problem has to come from our daily life as a student

Answer #1

A real life example that incorporates what i learnt is when I
had to take a vacation with my family to my relatives in a foreign
country (you can add up a country of your choice). We are a family
of four with my mother, father and a litlle sister. We figured the
total expenses adjusting for inflation in 12 months would be
$15,000. This can be treated as future value. We had no funds set
aside for the vacation so present value was zero. The monthly
compunded rate in bank deposit was 4% annually. So my parents
decide to set aside a mount every month for the same. Now they
needed to calculate how much do they have to contribute each
month.

Hence this concept came in handy:

n=12

rate= 4/12=0.33%=0.0033

PV=0

FV=15,000

Using excel formula: =PMT(0.0033,12,0,-15000)We get monthly
payment as $1,227.47

CPT payment from excel

Please provide a real-life example of what you learned. It can
be a present value, future value, number of periods, interest rate
(growth rate), or payment problem. You need to state the problem
and then solve the problem. The problem has to come from our daily
life as a student

Present Values:
Please provide the calculations in MS Excel for the present
value of an $7,000 goal in 7 years at 7% discounted on an annual,
semi-annual, quarterly, monthly, and daily basis to the nearest
penny.
Future Values:
Please provide the calculations in MS Excel for a future value
of an $7,000 investment today in 7 years at 7% compounded on an
annual, semi-annual, quarterly, monthly, and daily basis to the
nearest penny.
Present Value of an Annuity:
Please provide...

1) Please explain what is present value, and come up with one
example of the present value application in real life.
2) What happens to present value when you increase the discount
rate?
3) Please contrast compounding and discounting.

. Provide the structure of the Excel commands
to calculate pv(present value), fv(future value), rate(interest
rate), pmt(payment), nper(number of periods).

Provide a (real life) example of exploitation or manipulation in
the medical context. You can use an article from a newspaper or
other news-media, and make sure to append the link.Explain in 3-4
sentences.

What is an annuity? Can you provide some examples of real-life
annuities?

Why does money have a time value? Can you provide at least one
real-life scenario in which you can apply the concept of time value
of money?

a) Provide a real life example scenario for a paired-samples
t-test that includes sample data for N = 4 in each
condition. Do not only present the numbers; you need a reasonable
example of something that could be tested with a paired-samples
t-test.
b) Explain why your example is appropriate for a paired-samples
t-test.
c) Conduct the paired-samples t-test (two-tailed test
with an alpha of .05), showing your work for each step.

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 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...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 1 minute ago

asked 4 minutes ago

asked 26 minutes ago

asked 27 minutes ago

asked 29 minutes ago

asked 31 minutes ago

asked 32 minutes ago

asked 32 minutes ago

asked 33 minutes ago

asked 33 minutes ago

asked 37 minutes ago

asked 47 minutes ago