Question

In: Accounting

1. Find the correct excel formula to find the total in a retirment account: Monthly Amount...

1.

Find the correct excel formula to find the total in a retirment account:

Monthly Amount = $1250

Interest Rate = 2.0%

Years in Account = 12.3

2. How much interest did you gain if you invested in a retirement plan with a rate of 2.5% over 42 years? Your monthly deposits totaled $520.

Solutions

Expert Solution

The answer has been presented in the supporting sheet. For detailed answer refer to the supporting sheet.


Related Solutions

The formula for calculating the amount of money in a savings account that begins with an...
The formula for calculating the amount of money in a savings account that begins with an initial principal value (P) and earns annual interest (i) for (n) years is: P(1 + i)n Note that i is a decimal, not a percent interest rate: .1 NOT 10%              Write a python program that does the following: Prompt the user on three lines for principal, percent interest rate and number of years to invest (using descriptive prompts) Use a while loop to...
1. If the total amount of costs to account for equals $20,420,890 and there are 72,100...
1. If the total amount of costs to account for equals $20,420,890 and there are 72,100 equivalent units, calculate the average cost per unit. Select one: a. You can’t calculate the average cost per unit when using the weighted average method. b. $289.23 per unit c. $283.23 per unit d. You can’t calculate the average cost per unit when using the FIFO method. 2. What’s true about calculating the Cost of Goods Manufactured? Select one: a. Cost of Goods Sold...
 Estimate a Total Benefit and Total Cost formula for your product. In Excel, produce a...
 Estimate a Total Benefit and Total Cost formula for your product. In Excel, produce a chart that shows both functions with 50 data points (i.e. A=1…50). You decide what is A in your case (i.e. number of workers, hours of labor, etc. This is important because is going to determine your costs and profit).
What is Mirr? how do you find it using excel without using excel formula? Below is...
What is Mirr? how do you find it using excel without using excel formula? Below is cash flow. I found IRR is 15.59% and required return is 12% CF Y0 Y1 Y2 Y3 Y4 Y5 Y6 Capital spen $ (30,000,000.00) $ 15,062,400.00 Opp cost $   (5,000,000.00) NWC $   (1,120,000.00) $      (150,000.00) $      (170,000.00) $      140,000.00 $   1,300,000.00 OCF $     9,015,600.00 $ 11,392,500.00 $ 12,193,200.00 $ 10,435,800.00 $ (2,640,000.00) $   (3,960,000.00) CF $ (36,120,000.00) $     8,865,600.00 $ 11,222,500.00 $ 12,333,200.00 $...
answer needs to be entered by formula not numbers Excel assignment Loan amount $ 67,500 Interest...
answer needs to be entered by formula not numbers Excel assignment Loan amount $ 67,500 Interest rate 7% Loan term 5 Complete the following analysis. Do not hard code values in your calculations. All answers should be positive. Loan payment:..................... year- beginning balance- total payment- interest paid- principal paid- ending balance 1 2 3 4 5 Total interest paid.................
1.) If the account earns an interest rate of 24% compounded monthly, find the effective rate...
1.) If the account earns an interest rate of 24% compounded monthly, find the effective rate of interest: A. Compounded daily 360 days B. Compounded daily 365 days C. Compounded weekly D. Compounded monthly E. Compounded quarterly F. Compounded semi-annually G. Compounded annually 2.) What is the effective annual interest rate for a nominal interest rate of 24% compounded continuously?
**Please, Show work and Formula in excel sheet** Your initial loan amount is $200,000. The APR...
**Please, Show work and Formula in excel sheet** Your initial loan amount is $200,000. The APR is 5%. The number of years of the loan is 20 years. Generate the amortization table for the given loan. Assume this is the mortgage on your house. If you elected to pay an additional principal amount of $150.00 each month, in how many months would you pay off your mortgage? Not considering taxes, how much would you save in interest paid to service...
please show your work and formula on excel You can afford to pay $375 monthly car...
please show your work and formula on excel You can afford to pay $375 monthly car payments. Assume an annual interest rate of 6%, and assume 60 monthly payments. You can afford to put down $3,000. Can you afford to buy a car that costs $30,000?
Show in excel please with correct formula Solve all the problems using after tax cash flow...
Show in excel please with correct formula Solve all the problems using after tax cash flow analysis, even the book ask in some of them to use BTCF The Container Corporation of America is considering replacing an automatic painting machine purchased 9 years ago for $700,000. It has a market value today of $40,000. The unit costs $350,000 annually to operate and maintain. A new unit can be purchased for $800,000 and will have annualO&Mcosts of $120,000. If the old...
Question 1 John made equal monthly (end-of-the-month) deposits into an account for 10 years (total of...
Question 1 John made equal monthly (end-of-the-month) deposits into an account for 10 years (total of 120 deposits). He then made equal monthly (end-of-month) withdrawals (the first withdrawal occurs one month after the last deposit) of $1,000 for the next 12 years (total of 144 withdrawals), reducing the balance to zero. The account pays 8.4 percent per year compounded monthly. What was the monthly deposit?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT