Question

1)please show with excel

You buy an annuity which will pay you, and your heirs, $12,000 a year forever. What is the value of this perpetuity today at a 7% discount rate?

200,000.00 |
||

222,222.22 |
||

120,000.00 |
||

171,231.00 |
||

171,428.57 |

2)please show how with excel

You make annual payments on a 10 year $21,000 loan with 6% annual interest rate. What is the principle portion of your 3rd payment?

1,065.45 |
||

2,475.38 |
||

196.82 |
||

2,852.53 |
||

1,790.15 |

Answer #1

Q-1)

So, **the value of this perpetuity today is
$171,428.57**

**Option 5**

Q-2)

Calculating the Principal Portion in 3rd year using Excel PPMT function:-

So, the principle portion of your 3rd payment is $1790.15

Option 5.

*If you need any clarification, you can ask in
comments. *

**If you like my answer, then please up-vote as it
will be motivating
**

Please show the below problem in Excel:
John and Peggy would like to buy a house. They
have looked at their budget and determined that
they can afford a maximum monthly mortgage
payment of $1,100. Interest rates on 30-year,
fixed-rate mortgages currently have a nominal
annual interest rate of 7 percent with monthly
compounding (payments due at the end of each
month). Given these loan terms, what is the
maximum amount John and Peggy borrow today
to purchase a house...

Find the present value of a 20-year annuity with annual payments
which pays $600 today and each subsequent payment is 5% greater
than the preceding payment. The annual effective rate of interest
is 10.25%.
Answer: 7851.19
Please show which equations you used and please do not use excel
to answer this question.

Please use Excel to answer it: You are borrowing $21,000 with no
money down to buy a car. The terms of the loan call for equal
monthly payments for 5 years at 4.25% annual interest. What is the
amount of each monthly payment?

How much would you be willing to pay today for an ordinary
annuity that makes equal annual payments of $3,000 each year. You
will receive your first payment 7 years from today and you will
receive your last payment 32 years from today. The interest rate on
this annuity is 4.1%

You borrowed $50,000 for your business today with an interest
rate of 7.5%. Your first of five (5) equal annual payments on this
loan will be made one year from now.
PLEASE SHOW ALL EXCEL FORMULAS/FUNCTIONS
(A) What is your annual payment on this loan?
(B) Create an amortization table for this loan. The headings and
periods (years) for the amortization table are provided below.

You have been saving money to buy a home and today, you decided
to buy a home and take out $350,000 mortgage loan from a bank. This
loan requires you to make a monthly payment for 30 years and the
interest rate on your loan is 4% APR compounded monthly. What is
your monthly mortgage payment for this loan? Please show your excel
formula in your answer and explain step-by-step calculation to
arrive to your answer.

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

(Solving for r of an annuity) You lend a friend $30,000, which your
friend will repay in 5 equal annual end-of-year payments of $8,000,
with the first payment to be received 1 year from now. What rate
does your loan reciece?
The rate of return your loan will receive is ____%(round to
two decimal places)

You want to buy a new work truck for $42,000. You will make a
down payment of $4,000. What are your MONTHLY loan payments for a 5
year term. Use 9% annual nominal interest compounded monthly for
your loan.
Please show work either either through excel or written for
comparing and better understanding. I got 788.82 dollars

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

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 40 minutes ago

asked 50 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

asked 2 hours ago

asked 2 hours ago

asked 2 hours ago