A. Help Susan develop a model for the year that will meet her irregular monthly financial obligations while achieving her investment objectives and solve the model. B. If Susan decides she doesn’t want to include all her original $3,800 in her budget at the beginning of the year, but instead she wants to invest some of it directly in alternative longer-term investments, how much does she need to develop a feasible budget? II. Susan Wong's Personal Budgeting ModelAfter Susan Wong graduated from State University with a degree in management science, she went to workfor a computer systems development firm in the Washington, DC, area. As a student at State, Susan paid her normalmonthly living expenses for apartment_rent, food, and entertainment out of a bank account set up by her parents.Each month they would deposit a specific amount of cash into Susan's account. Her parents also paid her gas,telephone, and bank credit card bills, which were sent directly to them. Susan never had to worry about things likehealth, car, homeowners', and life insurance; utilities; driver's and car licenses; magazine subscriptions; and soon. Thus, while she was used to spending within a specific monthly budget in college, she was unprepared for theirregular monthly liabilities she encountered once she got a job and was on her own.In some months Susan's bills would be modest and she would spend accordingly, only to be confronted thenext month with a large insurance premium, or a bill for property taxes on her condominium, or a large credit cardbill, or a bill for a magazine subscription, and so on thenext month. Such unexpected expenditures would result in months when she could not balance her checkingaccount; she would have to pay her bills with her bank credit card and then pay off her accumulated debt ininstallments while incurring high interest charges. By theend of her first year out of school, she had hoped to have some money saved to begin an investment program, butinstead she found herself in debt.Frustrated by her predicament, Susan decided to get her financial situation in order. First, she sold thecondominium that her parents had helped her purchase and moved into a cheaper apartment. This gave her enoughcash to clear her outstanding debts, with_$3,800 left over to start the newyear with. Susan then decided to use some of the management science she had learned in collegeto help develop a budget. Specifically, she decided to develop a linear programming model to help her decide howmuch she should put aside each month in short-term investments to meet the demands of irregular monthlyliabilities and save some money. First, Susan went through all her financial records for the year and computed herexpected monthly liabilities for the coming year, as shown in the following table:MonthBillsMonthBillsJanuaryFebruaryMarch$2,750July$3,0502,8602.300AugustSeptember2.3351,9752.1201,670AprilMayOctober1,205November2,710June1,600December2,980 Susan's after-taxes-and-benefits salary is $29,400 per year, which she receives in 12 equalmonthly paychecks that are deposited directly into her bank account.Susan has decided that she will invest any money she doesn't use to meet her liabilities each month ineither 1-month, 3- month, or 7-month short-term investment vehicles rather than just leaving the money in aninterest-bearing checking account. The yield_on 1-month investments is 6% per year nominal; on 3-monthinvestments, the yield is 8% per year nominal; and on a 7-month investment, the yield is 12% per year nominal. Aspart of her investment strategy, any time one of the short-term investments comes due, she uses the principal aspart of her budget, but she transfers any interest earned to another long-term investment (which she doesn'tconsider in her budgeting process). For example, if she has $100 left over in January that she invests for 3 months, inApril, when the investment matures, she uses the $100 she originally invested in her budget, but any interest on the$100 is invested elsewhere. (Thus, the interest is not compounded over the course of the year.)Susan wants to develop a linear programming model to maximize her investment return during the year soshe can take that money and reinvest it at the end of the year in a longer-term investment program. However, shedoesn't have to confine herself to short term investments that will all mature by the end of the year; she cancontinue to put money toward the end of the year in investments that won't mature until the following year. Herbudgeting process will continue to the next year, so she can take out any surplus left over after December andreinvest it in a long-term program if she wants to.A. Help Susan develop a model for the year that will meet her irregular monthly financial obligations whileachieving her investment objectives and solve the model.B. If Susan decides she doesn't want to include all her original $3,800 in her budget at the beginning of theyear, but instead she wants to invest some of it directly in alternative longer-term investments, howmuch does she need to develop a feasible budget?

) LP model to maximize Susan's investment return while meeting her monthly liabilities is as follows…

hieving her investment objectives and solve the model. B. If Susan decides she doesn’t want to include all her original $3,800 in her budget at the beginning of the year, but instead she wants to invest some of it directly in alternative longer-term investments, how much does she need to develop a fe

hieving her investment objectives and solve the model. B. If Susan decides she doesn’t want to include all her original $3,800 in her budget at the beginning of the year, but instead she wants to invest some of it directly in alternative longer-term investments, how much does she need to develop a fe

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

You are given $50,000 to invest (not pay bills). How do you invest the money? Explain why this is a good investment(s) and how it would benefit one's financial goals.
HR wants to offer a Country Club membership for a group of employees that will cost the company $10,000 dollars a year. They will begin annually starting one year from now. 1. What amount must be invested today at 8.0% compounded annually to fund the scholarship program in perpetuity? 2. Given the current economic climate the CEO has lowered the initial investment amount you had available to $100,000, how much do you now have for the Country Club membership program?
Need help with this
You need to prepare for three large, upcoming project expenditures which will begin 3 years from now. The first required cash flow will be $56,000, the next year will require $94,000, and then $132,000. If you begin setting aside funds from your current budget next month, how much do you need to save each month in order to have enough to cover all three cash flows the day the first cash flow comes due? Assume you can invest these funds at 8.4 percent APR, compounded monthly. Please demonstrate how to calculate using a financial calculator, when possible.
3. Using both Payback and NPV results, which projects, if any, would yourecommend McGloire should fund? Justify your answer and include a criticalassessment of two nonfinancial qualitative factors that could affect the investment
Each of the following situations is independent. Work out your own solution to each situation, and thencheck it against the solution provided.2. The Morgans would like to send their daughter to a music camp at the end of each of the next fiveyears. The camp costs $1,000 a year. What lump-sum amount would have to be invested now to have$1,000 at the end of each year if the rate of return is:a. Eight percent?b. Twelve percent?
How do I solve this by hand and what is the equation?
4. Turton 4th, Prob. 9-18. You want to begin an investment plan to save for your daughter's college education. Because you believe that your newly born daughter will be a genius (just like you!), you are assuming the educational cost will be that of an Ivy League School. You plan to put money into an investment account, at the end of each year, for the next 18 years. You believe that you will need about $60,000 per year, each year, 19 through 22 years from now. a. Draw a discrete cash flow diagram for this situation. b. How much would you have to invest each year to pay for college and have a zero balance at the end of year 22? The effective annual interest rate of your investment is 8%. c. What interest rate would be needed if you could invest only $5000/yr?
(Click on the into a spreadsheet.) Annuity B C Premium paid today $24.098.32 $22,274.30 $31,240.13 $30,150.95 Annual benefit $3,200 $4100 $4,000 $4,200 Life (years) 20 10 15
You want to create an endowment income of $35,000 per year for Oxtordshire Charity, but the Tirst payment will not be made until the 4th year's time. a. If you can earn a return of 8% APR on your investment, and if the payment is made on a monthly basis, calculate how much to invest now? $5,133,086.81 B. $4,133,086.81 $5,233,086.81 $4,233,086.81 $5,250,000.81
The Jeffersons have asked you what would be needed to fund the children’s future college costs. Assume each child will begin college at age 18 and graduate in four years. Assume current costs are $24,000 per year and are expected to increase by 5% per year and investments earn 7%. A. Assuming no existing assets are dedicated to college, what is the annual savings amount required to fund the children’s education? The Jeffersons’ goal is to have an amount at the beginning of the freshman year for each child that is sufficient to fund a serial payment covering the $24,000 of current costs of college adjusted for inflation for each of the four years of college. Please include your calculator keystroke inputs [PV, I/YR, N, FV, and PMT (if needed)] for each step of this calculation. Also include whether any PMTs are in the end mode or the begin mode. B. What would you say to the Jeffersons about their education funding situation? Write a script of a single paragraph as if you…
Katie must decide which one of the following initiatives she will pursue. Each of the projects will take the same amount of capital to execute and will deliver the projected results in the same timeframe. Given current resources, she can only choose one. Which one should she choose? Project Samson: 50% probability of $1,000,000 profit; 50% probability of $0 Project Delilah: 30% probability of $750,000 base-line profit; 30% probability of 20% less than the base; 20% probability of 30% less than the base; and 20% probability of 10% more than the base Project Mark: 50% probability of $600,000 base-line profit; 25% probability of 20% less than the base; and 25% probability of 20% more than the base Project Omega: 60% probability of $1,500,000 profit; and 40% probability of $500,000 loss Group of answers. A. Project Omega B. Project Mark C. Project Samson D. Project Delilah Please solve in excel and please show workings.