Homework Answers
formula used :-
PV =-PV(C13/E13,D13*E13,F13)
Formula used :-
FV =FV(C29,D29,F29*E29)
Formulas used:-
Amount to be Financed=O30*(1-O31)
Monthly Payment =-PMT(O34,O33,O32)/12
I hope my efforts will be fruitful to you..?
Show all excel formulas used Ex. 3 JIf a dealer offers you a car at $275...
Show all excel formulas used
Ex. 3 JIf a dealer offers you a car at $275 monthly payment for 5 years plus $5,000 down. If you can get a similar loan from a bank at APR of 12%, what is the price that you're paying? Down payment Monthly payment Loan period months APR No. of compounding times per year Monthly rate Present Value Book formula Excel function Ex. 4 If you take out an $10,000 car loan that call for...
Problem 3: How many years will it take for an intial investment of $2000, earning 5.4%...
Problem 3: How many years will it take for an intial investment of $2000, earning 5.4% annually, to reach $10,000? NPER ? VY (Rate) PV PMT FV Compounding Periods CPT (Compute)? Problem 4: You have future plans to buy a house 5 years from now. You estimate that a down payment of $20,000 will be required at that time. To accumulate that amount, you want to start making monthly payments into an account paying 3.9% interest. What will your monthly...
You wish to buy a car for $12,000 at a 5% annual interest rate, compounded monthly....
You wish to buy a car for $12,000 at a 5% annual interest rate,
compounded monthly. The loan will be repaid in 5 years with monthly
payments. What is your monthly payment (calculated with the
equations on the next page)? Compare your answer to that obtained
with the built in function, PMT. Be sure to label all cells
appropriately. (There is no need to create a monthly payment table,
simply use the equations on the next page.)
Loans: where: and,...
Please complete parts A and B using Excel (see template below in pic 2), explaining the...
Please complete parts A and B using Excel (see template below in
pic 2), explaining the steps and writing out the Excel
formulas.
You just won a prize of $5,000 at the local talent show. You can receive the money all up front (t=0), or get a series of monthly or weekly payments as described below. In all cases, your discount rate is 5% APR (annual percentage rate). You may choose to get 39 monthly payments, with the first payment...
Problem #5: You want to buy a car that costs $21,000. The dealer wants a 10%...
Problem #5: You want to buy a car that costs $21,000. The dealer wants a 10% down payment and quotes a 15% APR for a 72-month loan. (a) What will be your monthly payment if the payment is made at the end of each month from the day you buy the car? (b) What will be your monthly payment if you tell the dealer that you will not make any down payment, but you will make your payments at the...
5. What is the interest rate if Fif = 1,000, PV 600, and t 50 periods?...
5. What is the interest rate if Fif = 1,000, PV 600, and t 50 periods? 6. What is the annual rate (APR) if compounding is monthly, and the interest rate is 4% 7. Let there be two compounding periods per year. Let the APR be 10%. What is the EAR'? 8. What is EAR if APR 6% and compounding is monthly? 9. Consider an annuity. What is the payment amount per month if PVA = 6%, and for five...
PLEASE ANSWER EVERYTHING ASAP THANK YOU!!! Investment X offers to pay you $3,728 per year for...
PLEASE ANSWER EVERYTHING ASAP THANK YOU!!!
Investment X offers to pay you $3,728 per year for 9 years, whereas Investment Y offers to pay you $4,690 per year for 5 years. What is the dollar difference (higher minus lower) in the present values of these two cash flow streams if the discount rate is 5.26 percent? Answer to two decimals. What are the annual cash flows (in $) of an annuity for 14 years, which costs $33,721 today, if the...
4. You are comparing two annuities that offer regular payments of $2,500 for five years and...
4. You are comparing two annuities that offer regular payments of $2,500 for five years and pay .75 percent interest per month. You will purchase one of these today with a single lump sum payment. Annuity A will pay you monthly, starting today, while annuity B will pay monthly, starting one month from today. Which one of the following statements is correct concerning these two annuities? Multiple Choice These annuities have equal present values but unequal future values. These two...
Q1 - Describe N,I/Y,PV,PMT, and FV. Q2 – Why is there one negative sign among the...
Q1 - Describe N,I/Y,PV,PMT, and FV. Q2 – Why is there one negative sign among the last three listed in Q1? Q3 – What is the difference between compounding and discounting? Q4 – What is an annuity? What are the different types of annuities? When are payments made? Q5 – What is a perpetuity? What is the relationship between PV and Interest? Q6 – Does FV get larger or smaller based off monthly compounding compared to quarterly compounding? Q7 –...
Please show work! You have decided to acquire a new car that costs $30,000. You are...
Please show work! You have decided to acquire a new car that costs $30,000. You are considering whether to lease it for three years or to purchase it and financing the purchase with a three-year installment loan. The lease requires no down payment and lasts for three years. Lease payments are $400 monthly starting immediately, whereas the installment loan will require monthly payments starting a month from now at an annual percentage rate (APR) of 8%. The discount rate (APR)...
Show all excel formulas used
Ex. 3 JIf a dealer offers you a car at $275 monthly payment for 5 years plus $5,000 down. If you can get a similar loan from a bank at APR of 12%, what is the price that you're paying? Down payment Monthly payment Loan period months APR No. of compounding times per year Monthly rate Present Value Book formula Excel function Ex. 4 If you take out an $10,000 car loan that call for...
Problem 3: How many years will it take for an intial investment of $2000, earning 5.4% annually, to reach $10,000? NPER ? VY (Rate) PV PMT FV Compounding Periods CPT (Compute)? Problem 4: You have future plans to buy a house 5 years from now. You estimate that a down payment of $20,000 will be required at that time. To accumulate that amount, you want to start making monthly payments into an account paying 3.9% interest. What will your monthly...
You wish to buy a car for $12,000 at a 5% annual interest rate,
compounded monthly. The loan will be repaid in 5 years with monthly
payments. What is your monthly payment (calculated with the
equations on the next page)? Compare your answer to that obtained
with the built in function, PMT. Be sure to label all cells
appropriately. (There is no need to create a monthly payment table,
simply use the equations on the next page.)
Loans: where: and,...
Please complete parts A and B using Excel (see template below in
pic 2), explaining the steps and writing out the Excel
formulas.
You just won a prize of $5,000 at the local talent show. You can receive the money all up front (t=0), or get a series of monthly or weekly payments as described below. In all cases, your discount rate is 5% APR (annual percentage rate). You may choose to get 39 monthly payments, with the first payment...
Problem #5: You want to buy a car that costs $21,000. The dealer wants a 10% down payment and quotes a 15% APR for a 72-month loan. (a) What will be your monthly payment if the payment is made at the end of each month from the day you buy the car? (b) What will be your monthly payment if you tell the dealer that you will not make any down payment, but you will make your payments at the...
5. What is the interest rate if Fif = 1,000, PV 600, and t 50 periods? 6. What is the annual rate (APR) if compounding is monthly, and the interest rate is 4% 7. Let there be two compounding periods per year. Let the APR be 10%. What is the EAR'? 8. What is EAR if APR 6% and compounding is monthly? 9. Consider an annuity. What is the payment amount per month if PVA = 6%, and for five...
PLEASE ANSWER EVERYTHING ASAP THANK YOU!!!
Investment X offers to pay you $3,728 per year for 9 years, whereas Investment Y offers to pay you $4,690 per year for 5 years. What is the dollar difference (higher minus lower) in the present values of these two cash flow streams if the discount rate is 5.26 percent? Answer to two decimals. What are the annual cash flows (in $) of an annuity for 14 years, which costs $33,721 today, if the...
Most questions answered within 3 hours.
-
The area of an elastic circular loop decreases at a constant
rate, dA/dt = −6.60×10−3 m2/s...
asked 1 minute ago -
The denaturation of proteins can be described by the
equilibrium
F⇌U
where F and U represent...
asked 1 hour ago -
Please answer what the maximum and minimum force is, and the
angle on the ion is...
asked 1 hour ago -
implement a program that reads a number of rows and a symbol.
The program will draw...
asked 1 hour ago -
Assume that when adults with smartphones are randomly selected,
45% use them in meetings or classes....
asked 1 hour ago -
Determine the number of formula units of
Na2SO4 and moles of oxygen contained in 8.11
moles...
asked 1 hour ago -
Explain in steps on the following code
What would be the output when executed
using System;...
asked 2 hours ago -
Given the information in the table, which of the following
statements is CORRECT?
Stock A
Stock...
asked 2 hours ago -
Write MARIE assembly language programs that do the following:
Write a program that inputs an integer...
asked 2 hours ago -
Explain an understanding of services and protocols.
Explain the job of DNS.
Explain the three email...
asked 2 hours ago -
(As soon as possible) Balance each of the following equations
according to the half-reaction method:
H2O2(aq)...
asked 2 hours ago -
A thin rod with a mass of 3.5kg and a length L=1.5 m is oriented
horizontally....
asked 2 hours ago