Homework Answers
Excel Function =PMT(C3/A3,A3*B3,D3,F3)
Add Answer to:
Q1. Assume you are 25 years old today. If you wish to have saved $500,000 by...
What are the three approaches to solving this problem? Sample Excel Quiz #1B/Test #1 Question Problems...
What are the three approaches to solving this problem?
Sample Excel Quiz #1B/Test #1 Question Problems in Business Finance 382, Test 1, Q12., Fall 2009 Q2a. Your old college roommate, Dennis Haydell (F382, Fa'09) is trying to get his start- up business off the ground and is looking for investment capital. If you lend him $35,000 today he has promised to make semi-annual repayments of $7.456.57 over three years. Make the appropriate calculation to determine if you should accept this...
how doni do this in excel and what is the interest rate? Suppose that you wish to purchase a car and that your bank...
how doni do this in excel and what is the interest rate?
Suppose that you wish to purchase a car and that your bank is offering to you a loan. You wish to explore the nature of this loan and the payments that you would have to make given certain circumstances such as the amount that you borrow. Fortunately, Excel offers a function (PMT) that calculates the payment for a loan based on constant payments and a constant interest rate....
You win the lottery! Do you wish to receive $2,000,000 in one payment now, or $167,000...
You win the lottery! Do you wish to receive $2,000,000 in one
payment now, or $167,000 per year for 30 years? To help you in your
decision, estimate the present value of the second option assuming
constant annual interest rates of 6%, 8%, and 10%. Expound on your
decision within a text box. (You may use the built-in PV function
within Excel)
Loans: where: and, interest due at the end of each month A = payment P = principal (amount...
Project: Assume that you are 18 years old and you would like to have $10000001000000 in...
Project:
Assume that you are 18 years old and you would like to have
$10000001000000 in your account by the time you are 6060 years old.
A list of various savings accounts was compiled in your Excel file.
Calculate the required initial (present value) deposit to the
savings accounts based on the interest rates in column
C compounded based on the values in column
D. Choose the savings account id (column
A) that requires the minimum initial investment. When you...
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,...
Huey, Dewey and Louie are triplets. They are 25 years old and are trying to set up...
Huey, Dewey and Louie are triplets. They are 25 years old and are trying to set up savings plans for themselves. They plan to retire at age 65. They each have different ideas. All APR’s are 4%. Huey’s plan: deposit $100 each month into the account and leave the money in the bank until he retires at age 65. Dewey’s plan: Dewey doesn’t want to be bothered with monthly payments like Huey. He wants to hang onto his money throughout the year, and then make just...
READ BEFORE YOU START: Solve each of the following question using 3 methods: pricing formulas, a...
READ BEFORE YOU START: Solve each of the following question using 3 methods: pricing formulas, a financial calculator, and Excel. When calculating using the pricing formula (e.g. Price of perpetuity P = C/r), please write the original formula and the steps where you plug in the number for each variable, and your final answers. When solving via a financial calculator, please indicate the inputs and output variable (e.g. PMT, N, PV, I/Y, and FV). When solving it using Excel, learn...
16.( You wish to save $500,000 in the next 25 years. You notice that a corporate...
16.( You wish to save $500,000 in the next 25 years. You notice that a corporate bond fund earns about 14 percent per year and that is where you put your savings. How much must you save in the end of each year to obtain your goal? a. $20,000.00 b. $2,749. 20 c. $4,370. 13 d. $2,000.00
As of the end of 2009, Amelia and Adam have a joint investment account of $400,000...
As of the end of 2009, Amelia and Adam have a joint investment account of $400,000 in assets. They are 50 years old and plan to retire in 15 years. They expect to live for another 20 years after they retire. They have a household annual income of $200,000 of which they spend $101,000. They would like to save enough money so that they can maintain the same consumption level of 101,000 a year. The inflation rate is 4%, and...
A) If you delay saving by 5 years, what would the interest rate (APR) need to...
A) If you delay saving by 5 years, what would the interest rate (APR) need to be for you to hit the target amount ($349,881.67)? Use excel RATE function and show values for arguments (nper, pmt, pv, fv, type, guess).. B) Convert that APR to an EAR. Use excel EFFECT function and show values for arguments (nominal_rate, npery) C) Amount you need in your account at retirement in order to spend $5000 each period? Use excel PV function and show...
What are the three approaches to solving this problem?
Sample Excel Quiz #1B/Test #1 Question Problems in Business Finance 382, Test 1, Q12., Fall 2009 Q2a. Your old college roommate, Dennis Haydell (F382, Fa'09) is trying to get his start- up business off the ground and is looking for investment capital. If you lend him $35,000 today he has promised to make semi-annual repayments of $7.456.57 over three years. Make the appropriate calculation to determine if you should accept this...
how doni do this in excel and what is the interest rate?
Suppose that you wish to purchase a car and that your bank is offering to you a loan. You wish to explore the nature of this loan and the payments that you would have to make given certain circumstances such as the amount that you borrow. Fortunately, Excel offers a function (PMT) that calculates the payment for a loan based on constant payments and a constant interest rate....
You win the lottery! Do you wish to receive $2,000,000 in one
payment now, or $167,000 per year for 30 years? To help you in your
decision, estimate the present value of the second option assuming
constant annual interest rates of 6%, 8%, and 10%. Expound on your
decision within a text box. (You may use the built-in PV function
within Excel)
Loans: where: and, interest due at the end of each month A = payment P = principal (amount...
Project:
Assume that you are 18 years old and you would like to have
$10000001000000 in your account by the time you are 6060 years old.
A list of various savings accounts was compiled in your Excel file.
Calculate the required initial (present value) deposit to the
savings accounts based on the interest rates in column
C compounded based on the values in column
D. Choose the savings account id (column
A) that requires the minimum initial investment. When you...
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,...
16.( You wish to save $500,000 in the next 25 years. You notice that a corporate bond fund earns about 14 percent per year and that is where you put your savings. How much must you save in the end of each year to obtain your goal? a. $20,000.00 b. $2,749. 20 c. $4,370. 13 d. $2,000.00
As of the end of 2009, Amelia and Adam have a joint investment account of $400,000 in assets. They are 50 years old and plan to retire in 15 years. They expect to live for another 20 years after they retire. They have a household annual income of $200,000 of which they spend $101,000. They would like to save enough money so that they can maintain the same consumption level of 101,000 a year. The inflation rate is 4%, and...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 11 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 11 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 11 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 11 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 11 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 11 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 11 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 11 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 11 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 11 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 11 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 11 months ago