MANAGERIAL ACCT (LL) W/ ACCESS CODE >C
4th Edition
ISBN: 9781323478684
Author: Braun
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 12, Problem 12.41BE
1.
To determine
The out-of-pocket cash for investment under the given options.
2.
To determine
The savings accumulated at age 52 under the given options.
3.
To determine
To explain: The results on out of pocket cost and accumulated savings at the age of 52.
4.
To determine
The worth of savings if keep as investment for next 10 years.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Please show in excel 2. Suppose another graduating student also has a financial plan with regard to starting his business. He intends to borrow $25,000 from his family and friends at the end of this year to start his business. He believes his business will earn $5000 after expenses one year after it begins, another $7000 after expenses the following year, $10,000 after expenses in each of the next , two years, and $3000 in the last year before it closes. Using a 4% annual interest discount rate, determine the net present value of this investment.
3. You have just received an email inviting you to accept a new credit card that offers you a $12,000 credit limit based upon your FICO score. You realize you can use that card now to charge your long overdue upscale vacation, which will cost $7500. The introductory terms of your new card indicates that no payment is due for the next two years, and the amount due will be charged a low 3% every month until you repay. Assuming you wait the full…
Upon starting you new job after graduation, you’ve been confronted with selecting investment for your 401K retirement plan. You have four choices for investing your money:
• A money market fund which has historically returned about 5% per year.
• A long-term bond which has earned an average annual rate of return of 8%
• A conservative common stock fund which has earned 10% per year.
• An aggressive common stock fund which has historically earned 14% per year.
a. If you were to contribute $3,600 per year (at the end of each year) for the next 35 years, how much would you accumulate in each of the above funds? (Use FV function)
b. Recalculate part a in a separate excel worksheet (same excel file), but now change your worksheet appropriately so that it allows for non-annual investments (monthly, weekly, quarterly etc.). The annual investment is still $3,600. For example, when you invest quarterly, you invest $900 (=$3,600/4) four times a year. What is the FV in each fund?
c. In the…
You opened a savings yesterday by depositing $10,000. You would like to be able to withdraw $2,000 per year for each of the next 4 years of college and still have $3,000 left in the account when you graduate. What interest rate does this account need to earn?
Chapter 12 Solutions
MANAGERIAL ACCT (LL) W/ ACCESS CODE >C
Ch. 12 - Prob. 1QCCh. 12 - (Learning Objective 2) After identifying potential...Ch. 12 - Prob. 3QCCh. 12 - Prob. 4QCCh. 12 - Prob. 5QCCh. 12 - Prob. 6QCCh. 12 - Prob. 7QCCh. 12 - Prob. 8QCCh. 12 - Prob. 9QCCh. 12 - (Learning Objective 5) Which of the following...
Ch. 12 - Order the capital budgeting process (Learning...Ch. 12 - Prob. 12.2SECh. 12 - Prob. 12.3SECh. 12 - Prob. 12.4SECh. 12 - Prob. 12.5SECh. 12 - Prob. 12.6SECh. 12 - Prob. 12.7SECh. 12 - Prob. 12.8SECh. 12 - Prob. 12.9SECh. 12 - Prob. 12.10SECh. 12 - Prob. 12.11SECh. 12 - Prob. 12.12SECh. 12 - Prob. 12.13SECh. 12 - Prob. 12.14SECh. 12 - Prob. 12.15SECh. 12 - Identify ethical standards violated (Learning...Ch. 12 - Prob. 12.17AECh. 12 - Compute payback period and analyze changes...Ch. 12 - Prob. 12.19AECh. 12 - Prob. 12.20AECh. 12 - Prob. 12.21AECh. 12 - Prob. 12.22AECh. 12 - Calculate the payback and NPV for a sustainable...Ch. 12 - Prob. 12.24AECh. 12 - Prob. 12.25AECh. 12 - Prob. 12.26AECh. 12 - Prob. 12.27AECh. 12 - Prob. 12.28AECh. 12 - Prob. 12.29AECh. 12 - Prob. 12.30AECh. 12 - Prob. 12.31AECh. 12 - Prob. 12.32AECh. 12 - Prob. 12.33AECh. 12 - Prob. 12.34AECh. 12 - Prob. 12.35AECh. 12 - Prob. 12.36BECh. 12 - Prob. 12.37BECh. 12 - Prob. 12.38BECh. 12 - Prob. 12.39BECh. 12 - Prob. 12.40BECh. 12 - Prob. 12.41BECh. 12 - Prob. 12.42BECh. 12 - Prob. 12.43BECh. 12 - Prob. 12.44BECh. 12 - Prob. 12.45BECh. 12 - Prob. 12.46BECh. 12 - Prob. 12.47BECh. 12 - Prob. 12.48BECh. 12 - Prob. 12.49BECh. 12 - Prob. 12.50BECh. 12 - Prob. 12.51BECh. 12 - Prob. 12.52BECh. 12 - Prob. 12.53BECh. 12 - Prob. 12.54BECh. 12 - Prob. 12.55APCh. 12 - Prob. 12.56APCh. 12 - Prob. 12.57APCh. 12 - Prob. 12.58APCh. 12 - Prob. 12.59BPCh. 12 - Prob. 12.60BPCh. 12 - Evaluate an investment using all four methods...Ch. 12 - Prob. 12.62BPCh. 12 - Prob. 12.63SCCh. 12 - Discussion Questions 1. Describe the capital...Ch. 12 - Prob. 12.65ACTCh. 12 - Prob. 12.66ACTCh. 12 - Prob. 12.67ACT
Knowledge Booster
Similar questions
- After completing successfully your FIN203 course, you have been asked by many of your family and friends about financial matters. You are trying your best to advise them. a) Your grandmother has been asked to invest in a product that offers to double her money in 3 years. Indicate the annual rate of return she is being offered b) Your parents have $5,000.00 to deposit. Alpha Bank offers 2 percent per year compounded monthly. Bravo Bank offers 2 percent compounded annually. Compute the amount of deposit after being kept 10 years at each bank. Explain the difference between the two (2) future values. c) Your best friend is saving $1,800.00 and will earn 0.17 percent per month. Determine the number of months until the account grows to $2,000.00. d) Your cousin plans to expand his business and will require $100,000.00 in 6.5 years. The rate of return will be 0.70 percent per month for the first two years. It will go up to 1.00 percent for the rest of the period. Compute the $ amount to set…arrow_forwardYour business finance course has motivated you to begin investing for retirement in your company's 401K plan. Your first $370 monthly investment will be made one month from today and you plan to retire 43 years from today. How much more will you have to invest each month, if you wait for 15 years before starting to invest to end up with the same amount of money at retirement? Assume a rate of return of 0.60 percent per month for your investments. Group of answer choices $1,196.80 $902.79 $826.81 $527.88 $611.34arrow_forwardUse the savings plan formula to answer the following question. Your goal is to create a college fund for your child. Suppose you find a fund that offers an APR of 4%. How much should you deposit monthly to accumulate $81,000 in 17 years? You should invest $ each month?arrow_forward
- SCHOOL VERSUS WORK The School you would like to attend cost 100,000 To help finance your education you need to choose whether or not to sell any of your 500shares of apple stock you bought five years ago.100 Apple bonds(each with a $1000 face value and a 3.25% coupon rate)that are five years from their 10 -year maturity date ,or a combination of both Provide the appropriate data and calculations that you would perform to make this decision.arrow_forwardExperts agree that the IRR of a college education is about 12%/yr. This results from the increased earnings over your lifetime. Draw a CFD that supports the 12% annual return over the 40 years of your career. State your assumptions.arrow_forwardUse Excel to solve the following problem. Assume that you are 39 years old planning for your future retirement at age 65. You think that you will be comfortable living on the proceeds from a $1,000,000 401K Retirement Account.a. If your investments grow at an average rate of 6% annually how much must you invest monthly to achieve your projected retirement fund total by the time you retire in 26 years?b. Assuming that when you do retire, you will re-direct your $1,000,000 investment portfolio into less volatile and more secure mutual funds. You expect that, invested in these sources, your portfolio will securely earn 4.5% annually. Based on your assumptions and the normal life expectancy of an American male or female (I determined this to be 81 years old), without consuming any of your principal, how much money will you have on a monthly basis to support your life?(I have worked this problem out on my own, I just want to be sure I applied the formulas and concepts correctly.)arrow_forward
- do assignments using excel and manually if possibly A student plans to open a business with the courage to borrow $1740,11 and will return the same amount every year for 5 years. If the loan interest from (Small Business Credit) is 6%/year. How much is the student's installment/year?arrow_forwardEngineering Economy Question is image To fund their child's college expenses, a family plans to invest $540 to a bank account at the end of this year. They will invest for the next 10 years and increase investment amount by 12% each year. What is the approximate total amount at the end of the planning horizon if the interest rate is 25%?arrow_forwardshow working using both a financial calculator and spreadsheet. after, show answer rounded off to the nearest dollar. Sam is in discussion with you about saving for his retirement. You are to advise him on how much he should deposit annually to meet his retirement needs. Assume that he will deposit a fixed annual amount for the next 20 years into a retirement savings account, starting one year from now. Sam has a son who will be attending college and plans to make 5 withdrawals (starting one year after making his final deposit into the retirement account) of $35,000 each to pay for his annual tuition for the following 5 years. Commercial Banks will be paying 6 percent on such retirement accounts for the next 25 years. Kindly advise Sam on how much he should place in the account annually to cover his retirement needs.arrow_forward
- In 9 years, David's child will go to university. David already has $5,800 set aside in the savings account but plans to contribute an additional $900 at the end of each year to this account for his children's education. He anticipates earning an annual return rate of 5% on his savings throughout that time (compounded annually). When his kid is ready to register for university, how much money will David have in this account? (Round time value factors to 3 decimal places and final answer to 2 decimal places. Omit the "$" sign in your response.)arrow_forwardSolve the problem. Suppose your father deposited in your bank account P10,000 at an annual interest rate of 0.5% compounded yearly when you graduate from kindergarten and did not get the amount until you finish Grade 12. How much will you have in your bank account after 12 years?arrow_forwardAfter completing your Bachelor of Business (Accounting) degree, suppose you secure a permanent position as an accountant. You drafted a financial plan to retire in 30 years from now. So, you are thinking about creating a fund that will allow you to receive $40,000 at the end of each year for 25 years after your retirement. The interest rates are expected to be 2.25% per annum during the 30year pre- retirement period and 1.75% during the retirement period. Required: a) To provide the 25- year, $40,000 a year annuity, calculate how much should be in the fund account when you retire in 30 years. b) How much will you need today as a single amount to provide the fund calculated in part (a) if you earn 2.35% per year during the 30 years preceding your retirement?c) What effect would a change (increase/decrease) in the interest rates, both during and prior to retirement, have on the values calculated in parts (a) and (b)? Explain why. d) (Using different interest rates) Assume that the…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,
Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSON
Intermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill Education
Financial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education