please help for the excel assignment of the finance You decide to start saving $850 quarterly...
please help for the excel assignment of the finance
| You decide to start saving $850 quarterly beginning today. How much will you have saved by the time you reach your planned retirement age 40 years from today if you can earn 5.2% on your savings? | ||||
| $850.00 | ||||
| 5.2% | ||||
| 40 | ||||
| 4 | ||||
| You win the lottery and have a choice of receiving annual payments (beginning one year from today) of $50,000 for 25 years - or a lump sum of $875,000. If the discount rate is 2.8%, how much do you gain by making the correct financial choice? | ||||
| $50,000.00 | ||||
| $875,000.00 | ||||
| 2.8% | ||||
| 25 | ||||
| PV of Pmts: | ||||
| Gain: | ||||
| A share of stock has most recently paid am annual dividend of $4.50. The next dividend will be paid one year from today. If you assume the dividend will grow in perpetuity at an annual rate of 2% as it has in the past, and the Required Rate of Return is 8.2%, what is the value of a share of this stock, | ||||
| $4.50 | ||||
| 8.2% | ||||
| 2.0% | ||||
| You decide to buy a new car, a new BMW 325, because you think you'll look hip driving it. The car cost $70,000, but you'll only need to finance $62,500. You can finance it at 4.1% APR for 6 years. What will your monthly payments be? | ||||
| $70,000.00 | ||||
| $62,500.00 | ||||
| 4.1% | ||||
| 6 | ||||
| 12 | ||||
| Answer: | ||||
Homework Answers
Add Answer to:
please help for the excel assignment of the finance
You decide to start saving $850 quarterly...
please I need help answering this question thank you all the information are in the picture...
please I need help answering
this question thank you all the information are in the picture
Task 6-8 Data 15 Year Mortgage 30 Year Mortgage Loan Amount Interest Rate Number of Payments $310,000.00 4.50% 180 $310,000.00 4.50% 360 Assignment Tasks Finance How much money will you save if you pay off the loan in 15 years instead of 30 years? (Please reference the total payment amounts in cells C39 and D39 to calculate the difference.) [5 points] Monthly Payment $2,371.48...
please help with the following: show on excel. Question 3. (2 marks) You invest $28,000 in...
please help with the following: show on excel.
Question 3. (2 marks) You invest $28,000 in an account today. The account will pay 7.2% compounded annually. How long will it take until you have $40,000 in the account? 4.88 years 4.94 years 5.13 years 5.20 years none of the above d) Question 4. (2 marks) You have just bought a car for $34,000. You borrowed the purchase price from the bank. The loan has a quoted rate of 8.2% compounded...
Today is your 21st birthday and you just decided to start saving money so you can...
Today is your 21st birthday and you just decided to start saving money so you can retire early. Thus, you are going to save $500 a month starting one month from now. You plan to retire as soon as you can accumulate $1 million. If you can earn an average of 8% on your savings, how old will you be when you retire? 33.39 years 42.87 years 54.39 years 64.71 years Travis is buying a car and will finance it...
nformation Flag question For questions 14-16, consider the following scenario. You decide to finance a 518,500...
nformation Flag question For questions 14-16, consider the following scenario. You decide to finance a 518,500 car at 3% interest rate for 4 years (48 months). Question What will your monthly payments be? Incorrect Answer Score 0.00 out of 1.00 Flag question Check Incorrect Score for this submission: 0.00/1.00 Question What is the total amount you will pay for the car? Incorrect Answer: Score 0.00 out of 1.00 Check question Incorrect Score for this submission: 0.00/1.00 Question How much interest...
A 1? В C D E F Н К How much will you need at retirement to ensure a 35-year annuity of $12,000 per month? In other word...
A 1? В C D E F Н К How much will you need at retirement to ensure a 35-year annuity of $12,000 per month? In other words, how much will you need on your retirement date in order to safely withdrawal $12,000 per month, starting in one month, for 35 years? Assume the retirement funds will be invested in a bond fund with an expected annual return of 4%. t2? How much is the monthly payment for a BMW...
1. You recently received a birthday gift of $500 and you decide to save it for...
1. You recently received a birthday gift of $500 and you decide to save it for later use. If you deposit it into an investment account that earns 6 percent interest, how much will be in the account in 3 years? 2. You borrowed $1,200 to buy a new computer and agreed to pay the loan back 3 years later; if the loan has a 10 percent interest rate, what is the balance you will owe at that time? 3....
Finance question, Please help! QUESTION 11 6.66666 poin If you are saving for retirement you should...
Finance question, Please help!
QUESTION 11 6.66666 poin If you are saving for retirement you should find that single company like Apple or Alphabet or Spotify and invest all of your funds in that single asset. Portfolio diversification slows down wealth accumulation by exposing your portfolio to losses that offset gains. True False QUESTION 12 6.66666 poin You have made the recommendation to a client to purchase an immediate annuity. This will convert a lump sum investment into periodic payments...
Bridgette wants to retire 36 years from now. She decides to start saving $400 each month...
Bridgette wants to retire 36 years from now. She decides to start saving $400 each month into a Roth IRA starting at the end of this month. If the IRA is expected to earn an average return of 9% annually, how much will she have in the account at the end of 36 years? Round to two decimal places 5. 6. Durran has recently acquired a rare art piece that he plans to put on display in his private collection....
Using Microsoft Excel, demonstrate your understanding of the Time Value of Money concepts discussed in the...
Using Microsoft Excel, demonstrate your understanding of the Time Value of Money concepts discussed in the text by answering the following questions. Upload your answer to canvas. 1. You graduate from school and get a job with an annual salary of $50,000. a. (1 point) Your boss calls you into the office and says she is happy with your performance and is going to give you a $1,000 raise. What percentage raise is this for you? b. (1 points) If...
Please answer alternative 1 only. Thank you. To finance a major expansion program, Manchester Mining PLC,...
Please answer alternative 1 only. Thank you.
To finance a major expansion program, Manchester Mining PLC, a major British mining company, needs to raise 100 million in pounds sterling. Due to the availability of extensive tax loss carry forwards, Manchester Mining's tax rate effectively equals zero over the next five years. The firm has to decide which one of the following mutually exclusive financing alternatives to adopt. Note that all of the loan alternatives stipulate annual debt service payments and...
please I need help answering
this question thank you all the information are in the picture
Task 6-8 Data 15 Year Mortgage 30 Year Mortgage Loan Amount Interest Rate Number of Payments $310,000.00 4.50% 180 $310,000.00 4.50% 360 Assignment Tasks Finance How much money will you save if you pay off the loan in 15 years instead of 30 years? (Please reference the total payment amounts in cells C39 and D39 to calculate the difference.) [5 points] Monthly Payment $2,371.48...
please help with the following: show on excel.
Question 3. (2 marks) You invest $28,000 in an account today. The account will pay 7.2% compounded annually. How long will it take until you have $40,000 in the account? 4.88 years 4.94 years 5.13 years 5.20 years none of the above d) Question 4. (2 marks) You have just bought a car for $34,000. You borrowed the purchase price from the bank. The loan has a quoted rate of 8.2% compounded...
nformation Flag question For questions 14-16, consider the following scenario. You decide to finance a 518,500 car at 3% interest rate for 4 years (48 months). Question What will your monthly payments be? Incorrect Answer Score 0.00 out of 1.00 Flag question Check Incorrect Score for this submission: 0.00/1.00 Question What is the total amount you will pay for the car? Incorrect Answer: Score 0.00 out of 1.00 Check question Incorrect Score for this submission: 0.00/1.00 Question How much interest...
A 1? В C D E F Н К How much will you need at retirement to ensure a 35-year annuity of $12,000 per month? In other words, how much will you need on your retirement date in order to safely withdrawal $12,000 per month, starting in one month, for 35 years? Assume the retirement funds will be invested in a bond fund with an expected annual return of 4%. t2? How much is the monthly payment for a BMW...
Finance question, Please help!
QUESTION 11 6.66666 poin If you are saving for retirement you should find that single company like Apple or Alphabet or Spotify and invest all of your funds in that single asset. Portfolio diversification slows down wealth accumulation by exposing your portfolio to losses that offset gains. True False QUESTION 12 6.66666 poin You have made the recommendation to a client to purchase an immediate annuity. This will convert a lump sum investment into periodic payments...
Bridgette wants to retire 36 years from now. She decides to start saving $400 each month into a Roth IRA starting at the end of this month. If the IRA is expected to earn an average return of 9% annually, how much will she have in the account at the end of 36 years? Round to two decimal places 5. 6. Durran has recently acquired a rare art piece that he plans to put on display in his private collection....
Please answer alternative 1 only. Thank you.
To finance a major expansion program, Manchester Mining PLC, a major British mining company, needs to raise 100 million in pounds sterling. Due to the availability of extensive tax loss carry forwards, Manchester Mining's tax rate effectively equals zero over the next five years. The firm has to decide which one of the following mutually exclusive financing alternatives to adopt. Note that all of the loan alternatives stipulate annual debt service payments and...
Most questions answered within 3 hours.
-
Propose an efficient synthesis of 2-Bromo-5-nitrotoluene from
benzene. Hint: 3 steps. Consider directing effects of substituents....
asked 2 hours ago -
Name the following coordination compounds using systematic
nomenclature.
1. [Co(H2O)6]Cl2:
2. [Cr(NH3)6](NO3)3:
3. K4[Fe(CN)6]:
4. Na[Au(CN)4]:...
asked 47 minutes ago -
This assignment will explore the impact of corporate decisions
on a local versus a global perspective....
asked 1 hour ago -
Given the function below, F(w,x,y,z)= x’z+w’z’+w’y
a) draw a logic diagram for an implementation which uses...
asked 1 hour ago -
The sandwich maker of the EE-Cole-Eye Sandwich Truck was just
fired (for a reason described below)...
asked 1 hour ago -
Most political philosophers believe we have a duty to obey laws,
even if the laws in...
asked 2 hours ago -
Which of the following are common negotiation outcome
mistakes?
a. Leave money on the table b....
asked 2 hours ago -
Convert the following quantities:
a) 0.819 atm to torr b) 512 mmHg to bar c) 11.2...
asked 3 hours ago -
C ++ Implement cat command
The purpose of this assignment is to provide practice using the...
asked 3 hours ago -
we
convert sugars into another form of stored potential energy. This
is called?
asked 4 hours ago -
The manufacturers of Oriental Spice Sauce are concerned that the
sodium levels in their product vary...
asked 4 hours ago -
PLEASE DON'T ANSWER IF YOU CAN'T ANSWER ALL OF THE QUESTIONS. I
DESPERATELY NEED HELP
Consider...
asked 4 hours ago