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.
-
In C++ code language please:
1. Created a linked list
2. Insert 5 values: 1, 10,...
asked 2 minutes from now -
By analogy with automobiles, defects in cancer critical genes
have been likened to broken brakes and...
asked 18 minutes ago -
Supposing Delta is an example of a very large US commercial
airline, how does the magnitude...
asked 22 minutes ago -
The total amount of shares that a corporation's charter allows
it to issue is:
Issued.
Authorized....
asked 23 minutes ago -
Which of the following statements is false? Explain what is
wrong with the statement.
a. A...
asked 30 minutes ago -
Vincent Simmons appeals from the trial court's order awarding to
his wife, Dorothy Simmons, a one-half...
asked 32 minutes ago -
A group of researchers has developed a method that they
hypothesize will improve the reading ability...
asked 32 minutes ago -
When 1 Liter volumes of the below solutions are mixed, which
will result in the precipitation...
asked 35 minutes ago -
A truck moving at 45 m/s passes a police car moving at 36 m/s in
the...
asked 34 minutes ago -
By using specific examples, explain how multinational firms
balance (or not as the case may be)...
asked 36 minutes ago -
Given X ~ Exp(1/8), we survey 100 at a time and are interested
in the distribution...
asked 54 minutes ago -
The size of an array declaration must be know by the computer at
_______ time.
runtime...
asked 43 minutes ago