can you please answer all parts to this question

B. c. e. Suppose California's populatoon is 34.5 mellion people, and its population is expected to grow by 2% annually. How long will it take for the population to double? Round your answer to the nearest whole number. years f. Find the PV of an ordinary annuity that poys $1,000 each of the next 6 years if the interest rote is 18%. Then find the FV of that same annuity. Round your answers to the nearest cent: PV of ordinary annuity: \$ FV of ordinary annuty: $ 9. How will the PV and FV of the annuity in part f change if it is an annuity due rather than an ordinary annuity? Round your answers to the neacest cent. PV of annuity due: $ FV of annuity due: $ h. What will the FV and the PV for parts a and c be ff the interest rate is 12% with semiannual compounding rather than 12% with annual compounding? Round your answers to the nearest cent. FV wh semannual compounding: $ pv with semianfual compounding: $ 1. Find the annual payments for an ordinary annuity and an annuty due for 12 years whth o pV of $1,000 and an interest rate of 10%, Round your answers fo the nearest cent. Annual payment for ordinary annuty: \$ Annual payment for annuty due? E Reparment of Prindipal (\$) interest (\$) c. Popsyment of Prindpas (s) interest (s) E Peparment of Principal (s) ieterest (\$) Choose the correct graph of future value as a function of time and rate. Note: blue line is for 0%, orange line is for 6%, and grey line is for 30%. The correct graph is 2. If the TVM is the only consideration, what nominal rate will cause all of the banks to provide the same effective annual rate as Bank A? Round your answers to two decimal places. 3. Suppose you don't have the $4,500 but need it at the end of 1 year, You plan to make a series of deposits - annually for A, serniannually for B, quarterly for C, monthly for D, and dally for E - with payments beginning today. How large must the payments be to each bank? Round your answers to the nearest cent. 4. Even if the five banks provided the same effoctive aninual rate, would a rational investor be indifferent between the banks? It is more likely that an imvestor would prefer the bank that compounded frequently. 1. Suppose you borrow $15,000. The interest rate is 10%, and it requires 4 equal end-of-year payments. Set up an amortization schedule that shows the annual payments, interest payments, principal repayments, and beginning and ending loan balances. Round your answers to the nearest cent. If your answer is zero, enter " 0 ". Excel Activity: Time value of money The data has been collected in the Microsoft Excel file below. Download the spreadsheet and perform the required analysis to answer the questions below. Do not. round intermediate calculotions. Enter your answers as positive values. Download spreadsheet Time value of monex:ad6266.xlsx a. Find the FV of $1,000 invested to earn 12% after 6 years. Round your answer to the nearest cent. 5 b. What is the investment's FV at rates of 0%,6%, and 30% after 0,1,2,3,4, and 5 years? Round your answers to the nearest cent: Choose the correct graph of future value as a function of bme and rate. Note: blue line is for 0%, orange fine is for 6%, and grey line is for 30%. The correct graph is c. Find the PV of $1,000 due in 6 years if the discoutit rate is 12%. Round your answer to the nearrst cent: d. A security has a cost of $1,000 and will return $4,000 after 6 years. What rete of return does the security provide? Round your answer to two decimal places. \% e. Suppose California's population is 34.5 milion people, and its population is expected to grow by 2% annually. How long will it take for the population to double? Round your answer to the nearest whole number. weass Choose the cocrect graph that shows how the payments are divided between interest and principal repayment over time The correct graph is Round your answers to the nearest cent. PV of investment: $ FV of imvestment: 5 k. Five banks offer nominal rates of 9% on deposits, but A pays interest annually, B pays semiannually, C pays quarterly, D pays monthly, and E pays daily. Assurne 365 days in a yeat. 1. What effective annual rate does each bank pay? If you deposit $4,500 in each bank today, how much will you have in each bank at the end of 1 year? 2 years? Round your answers to two decimal pAces. 2. If the TVM is the only consideration, what nominal rate will cause all of the banks to provide the same effective annual rate as Bank A? Round vour answers to two decimal ploces. B. c. e. Suppose California's populatoon is 34.5 mellion people, and its population is expected to grow by 2% annually. How long will it take for the population to double? Round your answer to the nearest whole number. years f. Find the PV of an ordinary annuity that poys $1,000 each of the next 6 years if the interest rote is 18%. Then find the FV of that same annuity. Round your answers to the nearest cent: PV of ordinary annuity: \$ FV of ordinary annuty: $ 9. How will the PV and FV of the annuity in part f change if it is an annuity due rather than an ordinary annuity? Round your answers to the neacest cent. PV of annuity due: $ FV of annuity due: $ h. What will the FV and the PV for parts a and c be ff the interest rate is 12% with semiannual compounding rather than 12% with annual compounding? Round your answers to the nearest cent. FV wh semannual compounding: $ pv with semianfual compounding: $ 1. Find the annual payments for an ordinary annuity and an annuty due for 12 years whth o pV of $1,000 and an interest rate of 10%, Round your answers fo the nearest cent. Annual payment for ordinary annuty: \$ Annual payment for annuty due? E Reparment of Prindipal (\$) interest (\$) c. Popsyment of Prindpas (s) interest (s) E Peparment of Principal (s) ieterest (\$) Choose the correct graph of future value as a function of time and rate. Note: blue line is for 0%, orange line is for 6%, and grey line is for 30%. The correct graph is 2. If the TVM is the only consideration, what nominal rate will cause all of the banks to provide the same effective annual rate as Bank A? Round your answers to two decimal places. 3. Suppose you don't have the $4,500 but need it at the end of 1 year, You plan to make a series of deposits - annually for A, serniannually for B, quarterly for C, monthly for D, and dally for E - with payments beginning today. How large must the payments be to each bank? Round your answers to the nearest cent. 4. Even if the five banks provided the same effoctive aninual rate, would a rational investor be indifferent between the banks? It is more likely that an imvestor would prefer the bank that compounded frequently. 1. Suppose you borrow $15,000. The interest rate is 10%, and it requires 4 equal end-of-year payments. Set up an amortization schedule that shows the annual payments, interest payments, principal repayments, and beginning and ending loan balances. Round your answers to the nearest cent. If your answer is zero, enter " 0 ". Excel Activity: Time value of money The data has been collected in the Microsoft Excel file below. Download the spreadsheet and perform the required analysis to answer the questions below. Do not. round intermediate calculotions. Enter your answers as positive values. Download spreadsheet Time value of monex:ad6266.xlsx a. Find the FV of $1,000 invested to earn 12% after 6 years. Round your answer to the nearest cent. 5 b. What is the investment's FV at rates of 0%,6%, and 30% after 0,1,2,3,4, and 5 years? Round your answers to the nearest cent: Choose the correct graph of future value as a function of bme and rate. Note: blue line is for 0%, orange fine is for 6%, and grey line is for 30%. The correct graph is c. Find the PV of $1,000 due in 6 years if the discoutit rate is 12%. Round your answer to the nearrst cent: d. A security has a cost of $1,000 and will return $4,000 after 6 years. What rete of return does the security provide? Round your answer to two decimal places. \% e. Suppose California's population is 34.5 milion people, and its population is expected to grow by 2% annually. How long will it take for the population to double? Round your answer to the nearest whole number. weass Choose the cocrect graph that shows how the payments are divided between interest and principal repayment over time The correct graph is Round your answers to the nearest cent. PV of investment: $ FV of imvestment: 5 k. Five banks offer nominal rates of 9% on deposits, but A pays interest annually, B pays semiannually, C pays quarterly, D pays monthly, and E pays daily. Assurne 365 days in a yeat. 1. What effective annual rate does each bank pay? If you deposit $4,500 in each bank today, how much will you have in each bank at the end of 1 year? 2 years? Round your answers to two decimal pAces. 2. If the TVM is the only consideration, what nominal rate will cause all of the banks to provide the same effective annual rate as Bank A? Round vour answers to two decimal ploces