Question

In: Finance

NEED TO SHOW ALL WORK IN EXCEL 1. What is the annual interest rate, if $10,000...

NEED TO SHOW ALL WORK IN EXCEL

1. What is the annual interest rate, if $10,000 grows to $12,166 over 5 years? (3)

2. Payments of $500 each are received every six months ($1,000 per year) for 5 years. The nominal annual interest rate is 5%. Using semi-annual compounding, what is the present value today? What is the present value of the payments today? (3)

3. What monthly annuitiy investment (deposit per month) is required to achieve $20,000 in 4 years, if the nominal annual interest rate is 6%? (3)

4. What is the effective annual rate of 14.9 percent compounded monthly? (3)

5. You wish to save money to provide for retirement. Beginning one year from now, you will begin depositing a annual fixed amount into a retirement savings account that will earn 8% annually. You will make 30 such deposits. Then, one year after making the final deposit, you will withdraw $100,000 annually for 20 years (no more deposits). You wish to have $50,000 left in the account after the 20-year retirement period ends (note that this final cash flow has the same sign as the annual withdrawals).The fund will earn 6% annually during the 20-year retirement period. How much should you deposit annually over the 30-year savings period? (6)

Solutions

Expert Solution

1)

Hence, Annual interest rate is 4.00%

2)

Hence, Present value of annuity is $4,376.03


Related Solutions

4) Interest (Show all of your work!) Find the interest rate required for an investment of...
4) Interest (Show all of your work!) Find the interest rate required for an investment of $10,000 to grow to $15,000 in 5 years if the interest is compounded as follows: a) Annually b) Quarterly 5) Inflation (Show all of your work!) Assuming annual compounding, find the time it would take for the general level of prices, in the economy, to double at the following annual inflation rates: a) 3% b) 8% 6) Time to Double (Show all of your...
PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a...
PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a polling station at an average of 4 per minute (Poisson) where the service rate is 50 per hour (Poisson). a. What is the average number of voters in the system with 5 voter booths? (10 pts) b. What is the minimum number of voting booths needed to keep the average time in the system under three minutes? (10 pts) PLEASE SHOW ALL WORK IN...
****ANSWERS ARE GIVEN BUT MUST SHOW ALL WORK; PLEASE (NO EXCEL OR SPSS)***** ---------------------------------------------------------------------- 1. To...
****ANSWERS ARE GIVEN BUT MUST SHOW ALL WORK; PLEASE (NO EXCEL OR SPSS)***** ---------------------------------------------------------------------- 1. To answer this question, refer to the following hypothetical data collected using replicated measures design. Subject 1 2 3    4 5 6 7 8    9 10 Pre 50 49 37 16 80 42 40 58 31 21 Post 56 50 30 25 90 44 60 71 32 22 A. In a two-tailed test of H 0 using α=0.05, what is p(obtained) for the...
You borrow $10,000 on 1/1/2020, at the annual interest rate of 4%, and will repay in...
You borrow $10,000 on 1/1/2020, at the annual interest rate of 4%, and will repay in 10 annual installments, beginning on 12/31/2020, and continuing at the end of each year for subsequent years.  The installments are not level, but will increase at an annual rate of 3% with the first payment of $x.  Thus, the second payment will be $x(1.03), the third payment will be $x(1.03)2, etc. (a)        Calculate $x. (b)       What is the total amount of payments?  (Just add the payments, without interest.) (c)        What...
show Excel ( show all work including formulars ) As a senior analyst for the company...
show Excel ( show all work including formulars ) As a senior analyst for the company you have been asked to evaluate a new IT software project. The company has just paid a consulting firm $50,000 for a test marketing analysis. After looking at the project plan, you anticipate that the project will need to acquire computer hardware for a cost of $400,000. The Australian Taxation Office rules allow an effective life for the computer hardware of five years. The...
show Excel ( show all work including formulars ) You are considering an investment in the...
show Excel ( show all work including formulars ) You are considering an investment in the stock market and have identified two potential stocks, they are Westpac Banking Corp. (ASX: WBC) and Singapore Airlines Ltd. (SGX: C6L). The historical prices for the past 10 years are shown in the table below. in the table below. Year ASX: WBC SGX: C6L 2009 23.70 13.82 2010 22.85 14.76 2011 21.01 11.1 2012 27.85 10.99 2013 30.66 9.59 2014 34.23 12.65 2015 30.85...
CAN YOU SHOW WORK ON EXCEL SHEET FOR THESE PROBLEMS 1- Mr. Heffernan’s net annual income...
CAN YOU SHOW WORK ON EXCEL SHEET FOR THESE PROBLEMS 1- Mr. Heffernan’s net annual income is: 85000-12837.50 85,000-74,901)* 25% + (74,900-18,451)x15%+(18,450*10%=72,163 2- Mr. Heffernan’s net Monthly income is: 72,163/12 =6,013.58 3. The Heffernan’s total monthly income is: Mr. Heffernan=6,013.58 Mrs. Heffernan = $2,000 6,013.58+$2,000= 8,013.58 7- Mr. Heffernan wants to save for his retirement. He is thinking of saving $1,250 a month in a 401K account that pays an annual rate of 3.5%. How much will he have in...
Please show all your work in Excel, please send me the spreadsheet / workbook. What is...
Please show all your work in Excel, please send me the spreadsheet / workbook. What is the market value of the following bond? Coupon 8% Maturity date 2038 Interest paid semiannually Par Value $1000 Market interest rate 10% What is the market value of the following bond? Coupon 9% Maturity date 2028 Interest paid semiannually Par Value $1000 Market interest rate 8% What is the yield to maturity of the following bond? Coupon 9% Maturity date   2027 Interest paid semiannually...
What is the annual interest rate, if $10,000 grows to $12,166 over 5 years? (Please indicate...
What is the annual interest rate, if $10,000 grows to $12,166 over 5 years? (Please indicate all steps taken)
Please use excel and show all work and formulas. (I will give your work a like...
Please use excel and show all work and formulas. (I will give your work a like if you do this) Size (1000s sq. ft) Selling Price ($1000s) 1.26 117.5 3.02 299.9 1.99 139.0 0.91 45.6 1.87 129.9 2.63 274.9 2.60 259.9 2.27 177.0 2.30 175.0 2.08 189.9 1.12 95.0 1.38 82.1 1.80 169.0 1.57 96.5 1.45 114.9 What are the p-values of the t test (for the slope estimate) and F test? What is the coefficient of determination? What is...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT