Please don't use excel to solve the problems and show your work.
Answer to Question 16.1:
Part (a):
Annual deposit = $1,000
Number of deposits = 7
Interest rate = 10%
Future value = $1,000*1.10^6 + $1,000*1.10^5 + … + $1,000*1.10 +
$1,000
Future value = $1,000 * (1.10^7 - 1) / 0.10
Future value = $1,000 * 9.48717
Future value = $9,487.17
Part (b):
Annual deposit = $1,000
Number of deposits = 7
Annual interest rate = 10%
Semiannual interest rate = 5%
Effective annual rate = (1 + Semiannual interest rate)^2 -
1
Effective annual rate = (1 + 0.05)^2 - 1
Effective annual rate = 1.1025 - 1
Effective annual rate = 0.1025 or 10.25%
Future value = $1,000*1.1025^6 + $1,000*1.1025^5 + … +
$1,000*1.1025 + $1,000
Future value = $1,000 * (1.1025^7 - 1) / 0.1025
Future value = $1,000 * 9.56031
Future value = $9,560.31
Please don't use excel to solve the problems and show your work. 16.1. (a) Calculate the...
Answer the following problems using an Excel spreadsheet. All calculations MUST use Excel's Time Value of Money Functions (demonstrated in class) as well as cell references to receive FULL credit. Make sure to set up the data for each problem so you can "point" to the appropriate values in your formulas. Each problem is worth 20 points. This assignment must be completed INDIVIDUALLY. THIS IS NOT A GROUP ASSIGNMENT. The file you submit in CANVAS must be one that YOU...
please help me solve this problem with excel formulas please and thank you!! A financial planning service offers a unique program for parents to save for a child's college education. Starting on the child's 12th birthday, annual deposits are made. The first deposit is $5,000 and the required deposit increases by $1000 each year, until the child's 18th birthday, when the final deposit is made. Beginning on the child's 19th birthday, four annual withdrawals of $10,000 can be made. Assuming...
Solve the problem. Show your work and equations! Please do not show screenshots of Excel as your work shown. 4. The company yesterday paid their annual dividend of $2.00 and the expected price in 2 years is $100. The dividend payment is expected to grow at 7%. i) What is the stock's required return? ii) what is the price today? Use annual compounding
Calculate all of the problems in the document below in an Excel spreadsheet or on a financial calculator. Please show your work in order to get credit. For each problem, state the inputs given, what you are being asked to find (the missing input), and then use the Finance function to get the correct answer (if using Excel). 1. If you wish to accumulate $100,000 in 5 years, how much must you deposit today in an account that pays an...
Please don’t use Excel and do all the parts of the questions. Show your work!!! Problem 1 Greg borrowed $100,000 to purchase a house. He agreed to repay the loan with equal monthly payments over a 30 year period at a nominal annual rate of 6 percent. a. What would be his monthly payment? b. What is the effective annual interest rate on the loan? c. Consider a closing fees of $2,000 on the loan. If he chooses to finance...
You begin to save for your newborn child's college education by depositing $200 per month in an account paying 4% interest per year. You increase the amount you deposit each month by 5% each year. With continuous investment and compounding ... incipal will have been investe (nearest $100) B. What would be the average monthly payment over those 18 years? (nearest $1) C. How much will have accumulated in the account by the time your child enters college 18 years...
should be explain it on excel Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (10 pts) (a) Assume monthly car payments of $500 per month for 4 years and an interest rate of 0.75% per month. 1. What initial principal will this repay? (b) Assume annual car payments of $6000 for 4 years and an interest rate of 9% per year. 1. What initial principal will this repay? (c) Assume monthly car...
SOLVE USING EXCEL SOLVER In anticipation of the immense college expenses of their child, a couple has started an annual investment program on the child's eighth birthday that will last until the eighteenth birthday. Judging from their expected financial position over the next 10 years, the couple estimates that they will be able to invest the following amounts at the beginning of each year: Year 1 2 3 4 5 6 7 8 9 10 Amount ($1000) 20 20 25...
Please solve all the 4 problems.. They are short solutions so please solve all the questions. Will rate you for sure 1. (10 points) The stock for a certain company pays a dividend of $0.84 per share. What would be the dividend payment by this company to an individual who owns 225 shares of the company's stock? 2. (10 points) What is the dividend yield of a stock that pays a dividend of $1.25 per share if that stock sells...
Kate and Ken are in the market for a vacation place. They find a small but pleasant condo in Orlando listed at $478,000. They decide that now is not the right time to buy and that they will wait five years. The condos in Orlando appreciated each year at 2.5%, and they want to know what a similar condo will sell for in five years. Please help them and find it out. (3 points) Terry would like to make a...