The following table shows the average life expectancies in several countries. Assume that all premiums you calculate are based on end-of-month deposits in a fund yielding 6.8% annual interest compounded monthly to be paid out when a person reaches the life expectancy.  Country Japan Canada U.K. U.S. Mexico China India Life Expectancy: Male 80 80 79 76 73 74 64 Life Expectancy: Female 87 84 83 81 79 77 68 Calculate the life insurance monthly premium that a 40-year-old female in Japan would pay for a $7,000,000 policy. ( Round your answer to the nearest cent.) $ ______

Q: Future value of an ordinary annuity. Fill in the missing future values in the following table for an…

A: using FV formula of excel to calculate the future value, =FV(rate,nper,pmt,[pv]) rate = rate of…

Q: An individual wants to deposit $112,100 into two investment accounts. One account pays 66% annual…

A: Note: Assuming, the question has repeated rate of return displayed, hence taking 6% and 15%, other…

Q: (USING EXCEL FUNCTION PLEASE) You wish to plan your Bahamas Islands vacation. You estimate that it…

A: Compound = Monthly = 12Future Value = fv = $15,000Monthly Payment = p = $637.66Time = t = 24Payment…

Q: per year and the cash value is expected to be $1.5 million at retirement. Approximately how many…

A: The given problem can be solved using NPER function in excel. NPER function computes no. of years/…

Q: อ [What is the APR on your personal credit card(s)?] (4.7) 4-52. A financial consultant offers you a…

A: To solve this problem, we can use the concept of the annuity formula. The formula for the present…

Q: Please help me with 9-7 ??‍♀️

A: Excel Spreadsheet:

Q: A local bank advertises the following deal: "Pay us $100 at the end of each year for 12 years and…

A: The objective of this question is to calculate the present value of a perpetuity deferred for 12…

Q: Identify the items that appear on an Income Statement. cash balance revenues product purchases cost…

A: Income statement is a financial statement that indicates the financial performance of company for a…

Q: Banking. Arlo has an income of $55,000 that he is willing to spend over a year. If his bank…

A: Cash Management refers to make number and amount of withdrawals efficiently to make opportunity cost…

Q: What annual payment must you receive in order to earn a 6.5% rate of return on a perpetuity that has…

A: The objective of the question is to find out the annual payment that one must receive to earn a 6.5%…

Q: What is the value today of receiving $2,674.59 per year forever? Assume the first payment is made…

A: Present value refers to the current value of an asset that will be present at some future date which…

Q: Isaac Diez of Brazil. Isaac Diez Peris lives in Rio de Janeiro, Brazil. While attending school in…

A: The calculation of exchange rate concept is done in the forex calculation. The exchange rate concept…

Q: Suppose that a woman deposits $10,000 into an investment fund that guarantees to pay 0.5% interest…

A: Effective annual interest rate:The effective annual interest rate is a critical concept in the world…

Q: What's the rate of return you would earn if you paid $3,480 for a perpetuity that pays $70 per year?…

A: The objective of this question is to calculate the rate of return on a perpetuity. A perpetuity is…

Q: A perpetuity pays $85 per year and costs $950. What is the rate of return? 8.95% 9.39% 9.86%…

A: The objective of the question is to calculate the rate of return on a perpetuity. A perpetuity is a…

Q: An annuity with a cash value of $9,900 pays $290 at the beginning of every month. The investment…

A: Loans are paid by monthly payments that carry the payment for interest and payment for loan also but…

Q: Because it is unlikely she will be able to visit you this year, your wealthy Canadian aunt wants to…

A: Due to uncertain future factors, risk is arises. Exchange rate (ER) fluctuates continuously. To…

Q: Lee wants to know how much he will have available to spend on his trip to Costa Rica in 2 years if…

A: The amount available to spend is calculated as future value of account.

Q: Someone needs to make the following annuity payments to an individual: £445 paid at the end of each…

A: The PV of an investment refers to the combined value of the cash flows of the investment assuming…

Q: ution to such a

A: Given contribution as, $5,000 to $3,000 per year.

Q: Annuity X pays $115 at each year-end for 3 years. Annuity Y pays $105 at the beginning  of each year…

A: An annuity refers to a series of periodic payments made in exchange for a lump sum payment.…

Q: An insurer needs to make the following annuity payments to an individual: £744 paid at the beginning…

A: Present value is a financial concept that refers to the value of a future cash flow or stream of…

Q: was financed with a 6% (Canada, so semi-annual compounding) 25 year mortgage. a. b. How much would…

A: Price of house=$450000Down payment=25%Interest rate=6%Period=25 years

Q: which of the following banks would you choose for a savings account based on the following rates…

A: Banks provide interest on deposited amount at fixed rate. Higher the rate, higher will be the…

Q: The following table shows the average life expectancies in several countries. Assume that all…

A: Insurance premium refers to the periodic sum extended by the insured to the insurer. This is the…

Q: An insurer needs to make the following annuity payments to an individual: £744 paid at the…

A: Present value is a financial concept that refers to the value of a future cash flow or stream of…

Q: 17. You deposit $8,000 in a bank account today. You make another deposit of $14,000 into the account…

A: Bank deposit today = $8,000 Deposit on first year = $14,000 Deposit on second year = $10,000…

Q: At your favorite annuity store. Annuities-R-Us, you see a security that offers 46 equal payments,…

A: Annuity refers to the contract between the insurer and the insurance company against regular…

Q: you want to go to Europe 4 years from now, and you can save $3300 per year, beginning one year from…

A: Future value of annity , FV = PMT * ((1+r)^n - 1)/r Here,PMT = $3300r = 0.085n=4FV=?

Q: An annuity has a deposit of $50 per month and a value of $10,000 after 8 years. What interest rate…

A: The idea of the time value of money (TVM) states that money you have now is incredibly valuable you…