1) For PMT the calculation will be in Excel =PMT(8%/1,8*1,you want $88,000) =$8,273 you need to pay annually
2) APR Formula is APR=((Fees+Interest/Principal/No.of Days)*365)*100 so the calculation will be
((0+$18,000/$46,000/2920)*365)*100=4.89%Interest Rate
3) $36,300*9=$326,700 Total Payment ROI 7% for 9 years will be=$160,083
you need to pay $326,700-$160,083=$166,617
4) Scenario a) $20,000
Scenario b) $3,200*8=$25,600*5/100*4= $5,120+$25,600=$30,720
Scenario c) 4th year $2,900+$2,900*5%*4=$12,180
end of 5th year will get $20,00 so the total calculation after 5th year will be=$20,000+ ($20,000*5/100)=$21,000+$12,180=$33,180
So the C option will be more monetary benefited.
You decide that you need $88,000 in 10 years in order to make a down payment...
Instructions: Using Financial Formulas in Excel, answer the following time value of money problems in a single Excel worksheet. You can round to the nearest dollar. You must turn in your answers in an Excel document. 1. How much interest is earned in an account by the end of 5 years if $30,000 is deposited and interest is 4% per year, compounded semi-annually? 2. What is the balance in an account at the end of 10 years if $6,500 is...
Instructions: Using Financial Formulas in Excel, answer the following time value of money problems in a single Excel worksheet. You can round to the nearest dollar. You must turn in your answers in an Excel document. 1. How much interest is earned in an account by the end of 5 years if $30,000 is deposited and interest is 4% per year, compounded semi-annually? 2. What is the balance in an account at the end of 10 years if $6,500 is...
Suppose you are buying a house that cost $300,000. You make a 10% down payment and are also going to make semiannual payments for next 10 years on the balance of the loan which you are financing at 5% APR. Also, the IRS allows the tax exemption for the mortgage interest payment at the end of each year and your tax rate is 30% (i.e. Tax saving = annual interest * tax rate). Using the given information, construct the amortization...
only numbers 2,3, and 6 You are trying to decide a present worth of a contract. You will receive $10,000 when the contract is signed, a $20,000 payment at the end of Year 1, and $30,000 at the end of Year 2. and $40,000 at the end of Year 3, and $50,000 at the end of Year 4 when the project is completed. Your annual costs for this project are $10,000 per year. What is the present worth of the...
I need help on question 10. Time Value of Money Exercise: Question 1: Assume you deposit $700 every three months at ercent annual rate, compounded $700 every three months at a 6 percent am much will you have at the end of 20 years? Question 2: You borrow a five-year $13.000 loan with monthly percentage rate (APR) on the loan? 3,000 loan with monthly payments of $250. What is the annual Question 3: How much would you have to invest...
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).17. If you invest $17,500 per year for 17 years (all payments made at the beginning of each year), you will have accumulated...
11-16 I need help quick 9. You are offered an annuity that will pay $24,000 per year for 11 years (the first payment will occur one year from today). If you feel that the appropriate discount rate is 13%, what is the annuity worth to you today? AnnPay - 24,000 DR = 13 S 134PMT -24,00 world tried It Yrs 86-59 CK NO 1 FV-O Current value of annuity in 136,486.59 10. If you deposit $16,000 per year for 12...
9. You are offered an investment with a quoted annual interest rate of 6.75% with quarterly compounding of interest. What is your effective annual interest rate? 10. You are offered an annuity that will pay $15,000 per year for 20 years (the first payment will occur one year from today). If you feel that the appropriate discount rate is 3%, what is the annuity worth to you today? 11. If you deposit $6,500 per year (each deposit is made at...
I need help on question 8. Time Value of Money Exercise: Question 1: Assume you deposit $700 every three months at ercent annual rate, compounded $700 every three months at a 6 percent am much will you have at the end of 20 years? Question 2: You borrow a five-year $13.000 loan with monthly percentage rate (APR) on the loan? 3,000 loan with monthly payments of $250. What is the annual Question 3: How much would you have to invest...