please provide formula answer is provided
2. What is the annual payment required to save $2,000,000, over 40 years, compounded monthly at 6%? answer is 12923.071841351
If you are doing it in excel then the formulae for both the questions are as follows:
1.You have to use the Future value(FV) function for this which is =FV(2.0625%,30,,1650) =$3,044.18
2.For the monthly payment you have to use the PMT function which will be =PMT(6%,40,,2000000) =$12,923.07.
please provide formula answer is provided What is the future value of $1,650 invested at 24.75%,...
1. What is the future value in 7.4 years of $8651 invested in an account with a stated annual interest rate of 10%, compounded annually? 2. What is the future value in 14 years of $818 invested in an account with a stated annual interest rate of 4.3%, compounded semi-annually? 3. What is the future value in 5 years of $7922 invested in an account with a stated annual interest rate of 5.8%, compounded monthly 4. What is the future...
What is the future value of $119,000 invested for 5 years at 8% compounded monthly? (a) State the type amortization future value present value ordinary annuity sinking fund (b) Answer the question. (Round your answer to the nearest cent.) $
Using a financial calculator or spreadsheet, calculate the future value in 5.50 years of $14,900 invested today in an account that pays a stated annual interest rate of 6%, compounded monthly. The future value,FV, on this deposit is $_____. (Round to the nearest cent.)
Please write down all the steps. What is the future value 10 years from now of $1,800 invested today at a periodic interest rate of 10% compounded annually? Assuming a MARR of 14%, how much should you save each month to accumulate $1,000,000 over the next 25 years? A construction company purchases a truck for $125,000, and will sell it for $20,000 at the end of five years. The annual operating cost of the truck is $40,000. What is the...
6. Which of the following equations represent the future value formula of $500 invested at 10% compounded quarterly for 5 years? A. 500 (1 +.1095 B. 500 (1 + .05)10 C. 500 (1 + .025)20 D. 500 (1 +.10)20
1. In a future value of 1 table: Annual Rate Number of Years Invested Compounded () Rate of Interest (b) Number of Periods a. 10% Annually b. 8% Quarterly 10% Semiannually 2. In a present value of an annuity of 1 table: Annual Rate Number of Years Invested Number of Rents Involved Frequency of Rents (a) Rate of Interest (6) Number of Periods 1096 26 Annually 12% 15 30 Semiannually 8% Quarterly LINK TO TEXT Question Attempts: 0 of 3...
What is the future value of $1,565 invested for 6 years at 2.2 percent compounded quarterly? Round your answer to two decimal places.
What is the future value of $1 invested for 10 years if the 12 percent annual rate of interest is compounded quarterly? (A) $2.93 B $3.25 $3.26 $2.30
please show work. 2. Calculate the Future Value of $200,000 invested for 5 years at an interest rate of 3.75%, compounded annually.
What is the future value of $100,000 invested to an annual rate of 12% after 40 years?