You decide to make monthly payments into a retirement fund earning 4.75% compounded monthly. Note: Payments are made at the end of each period. Use this information for the questions below. Use the Saving for Retirement information above to answer this question. If your monthly payments are $147, how much will you have in your retirement fund after 40 years? S____________. Round to the nearest dollar.

You plan to place $1,200 per year into a Roth IRA. You expect to earn 6% APR and you will place this amount into the account for 35 years. How much will you have in the account in 35 years? Round to the nearest $1,000.

You would like to have enough money saved to receive a $90,000 per year perpetuity after retirement. The annual interest rate is 8 percent. Required: How much would you need to have saved in your retirement fund to achieve this goal? a) Assume that the perpetuity payments start on the day of your retirement. b) Assume that the perpetuity payments start one year from the date of your retirement.

At age 30, to save for retirement, you decide to deposit $300 into an IRA at the end of each month at an interest rate of 6% per year compounded monthly.   How much will you have from the IRA when you retire at age 65? Use this formula:     Find how much of the total amount is from interest.

You are planning to make monthly deposits of $500 into a retirement account that pays 7.7 percent interest compounded monthly. If your first deposit will be made one month from now, how large will your retirement account be in 30 years?

At the age of 30, to save for retirement, you decide to deposit $70 at the end of each month in an IRA that pays 4% compounded monthly. a. Use the following formula to determine how much you will have in the IRA when you retire at age 65. P[(1+r)²-1] A = A: or (7) b. Find the interest. ID a. You will have approximately $ in the IRA when you retire. (Do not round until the final answer. Then round to the nearest dollar as needed.) b. The interest is approximately $ (Use the answer from part a to find this answer. Round to the nearest dollar as needed.)

In 2012 the maximum Social Security deposit by an individual was $8,386.75. Suppose you are 27 and make a deposit of this amount into an account at the end of each year. How much would you have (to the nearest dollar) when you retire if the account pays 2% compounded annually and you retire at age 65?_____$

Windswept, Inc.2017 Income Statement($ in millions) Net sales $ 11,000   Cost of goods sold   8,200   Depreciation   395   Earnings before interest and taxes $ 2,405   Interest paid   110   Taxable income $ 2,295   Taxes   689   Net income $ 1,606        Windswept, Inc.2016 and 2017 Balance Sheets($ in millions)     2016     2017       2016     2017   Cash $ 420   $ 445   Accounts payable $ 2,060   $ 2,005   Accounts rec.   1,210     1,110   Long-term debt   1,120     1,580   Inventory   1,980     1,820   Common stock   3,460     3,190   Total $ 3,610   $ 3,375   Retained earnings   700     950   Net fixed assets   3,730     4,350                 Total assets $ 7,340   $ 7,725   Total liab. & equity $ 7,340   $ 7,725      What were the total dividends paid for 2017?

please show all work and state answer clearly

Use the excel and follow the step Like you did last question and please use excel