P2 5. Mr. Aumentadodeposits P1500 in a retirement account earning, 3.7 percent compoundedannually. If he continues to put P1500 into the account each year, how muchwill her account balance be after 5 years?YearBalance1....Amount Deposited New Balance Interest Total

Compound Interest is referred as the interest on the principal as well as on the accumulated…

Answered: 5. Mr. Aumentado deposits P1500 in a…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 38P: Suppose you are borrowing 25,000 and making monthly payments with 1% interest. Show that the monthly...

See similar textbooks

Similar questions

Forrester and Cohen is a small accounting firm, managedby Joseph Cohen since the retirement in December of hispartner Brad Forrester. Cohen and his three CPAs can togetherbill 640 hours per month. When Cohen or another accountantbills more than 160 hours per month, he or she gets an additional"overtime" pay of$62.50 for each of the extra hours: this is aboveand beyond the $5,000 salary each draws during the month.(Cohen draws the same base pay as his employees.) Cohenstrongly discourages any CPA from working (billing) more than240 hours in any given month. The demand for billable hours forthe firm over the next 6 months is estimated below: Cohen has an agreement with Forrester, his former partner,to help out during the busy tax season, if needed, for an hourly feeof $125. Cohen will not even consider laying off one of his colleaguesin the case of a slow economy. He could, however,…
A 5-year annuity of ten $5,300 semiannual paymentswill begin 9 years from now, with the first payment coming 9.5 years from now. If thediscount rate is 12 percent compounded monthly, what is the value of this annuityfive years from now? What is the value three years from now? What is the currentvalue of the annuity?
Rollo Megabux has $1 million to invest in stocks orbonds. The percentage yield on each investment during thecoming year depends on whether the economy has a goodor a bad year (see Table 17). It is equally likely that theeconomy will have a good or a bad year.a If Rollo is risk-neutral, how should he invest hismoney?b For $10,000, Rollo can hire a consulting firm toforecast the state of the economy. The consulting firm’sforecasts have the following properties:P(good forecast|economy good) .80P(good forecast|economy bad) .20Should Rollo hire the consulting firm? What are EVSIand EVPI? Economy EconomyHas Good Has BadYear YearYield on stocks 22% 10%Yield on bonds 16% 14%
In a particular bond market, thetwo - year par yield at time t = 0is 4.15% and the issue price attime t = 0 of a two - year fixedinterest stock, paying coupons of8% annually in arrears and redeemed at 98, is $105.40 per$100 nominal. Calculate: (a) theone - year spot rate (b) the two -year spot rate
You currently own 600 shares of JKL, Inc. JKL is an all-equity firm that has 75,000 shares of stock outstanding at a market price of $40 a share. The company’s earnings before interest and taxes are $140,000. JKL has decided to issue $1 million of debt at 8 percent interest. This debt will be used to repurchase shares of stock. If the cost of equity is 25%, the WACC is 16% and cost of debt is 10%, what will be the implied D/E ratio?
Michelle owns a house in which she keeps valuables worth 100,000 which can get stolen with probability 1%. She can purchase coverage C of the amount C ∈ [0; 100,000] at premium π = 0.05 dollars for each dollar covered. Her Bernouilli utility function is u(w) = ln(w). Assume she has no other assets. 1. Set up her maximization problem. 2. How much insurance will she choose to buy? 3. How much profits does the insurance company earn on insuring Michelle? 4. Does the fact that the insurance company earn profits mean that Michelle is worse off com-pared to the situation in which she is not insured? Explain what is happening. 5. How much insurance will she buy if insurance companies charge an actuarially fair insurance rate?
9.5 Capital Healthplans Inc. is evaluating two different methods for providing home health services to its members. Both methods involve contracting out for services, and the health outcomes and revenues are not affected by the method chosen. Therefore, the net cash flows for the decision are all outflows. Here are the projected flows: Year Method A ($) Method B ($) 0 (300,000) (120,000) 1 (66,000) (96,000) 2 (66,000) (96,000) 3 (66,000) (96,000) 4 (66,000) (96,000) 5 (66,000) (96,000) What is each alternative’s IRR? If the opportunity cost of capital for both methods is 9 percent, which method should be chosen? Why?
Explain in some detail how the PrecisionTree calculations in Figure 6.11 for the Acme problem are exactly the same as those for the hand-drawn decision tree in Figure 6.6. In other words, explain exactly how PrecisionTree gets the monetary values in the colored cells in Figure 6.11. If your answer is negative number, enter "minus" sign. Market EMV Great ( $18 × - $ ) = $ Fair ( $18 × - $ ) = $ Awful ( $18 × - $ ) = $ Total 0.45 × __ $ + 0.35 × ___$ + 0.20 × ___ $ = ___ $
Michelle, age 45, currently makes $95,000. Her wage replacement ratio is determined to be 75 percent. She expects that inflation will average 3 percent for her entire life expectancy. She expects to earn 8 percent on her investments and retire at age 65, possibly living to age 95. She has sent for and received her Social Security benefit statement, which indicated that her Social Security retirement benefit in today’s dollars adjusted for early retirement is $20,000 per year. How much capital does Jordan need to retire at age 65?.
Audrey Sanborn has just arranged to purchase a $550,000vacation home in the Bahamas with a 20 percent down payment. The mortgage hasa 6.1 percent stated annual interest rate, compounded monthly, and calls for equalmonthly payments over the next 30 years. Her first payment will be due one monthfrom now. However, the mortgage has an eight-year balloon payment, meaning thatthe balance of the loan must be paid off at the end of Year 8. There were no othertransaction costs or finance charges. How much will Audrey’s balloon payment bein eight years?
Sonia wich to esatablish a trust fund from which her son can withdraw $6,000 every six months for 15 years, when he reach 16 years old. At the end of which time he wil recevie the remaining money in the trust, which you would like to be $25,000. The trust will be invested at 6% per annum componded semi-annually. How large should the trust be?
You are planning to save for retirement over the next 30 years.To do this, you will invest $800 a month in a stock account and $350 a month in abond account. The return of the stock account is expected to be 11 percent, and thebond account will pay 6 percent. When you retire, you will combine your money intoan account with an 8 percent return. How much can you withdraw each month fromyour account assuming a 25-year withdrawal period?

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS

5. Mr. Aumentado deposits P1500 in a retirement account earning, 3.7 percent compounded annually. If he continues to put P1500 into the account each year, how much will her account balance be after 5 years? Year Balance 1 Amount Deposited New Balance Interest Total