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.
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.
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
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.
Net Present Value and Internal Rate of Return. Below are the projected revenues and expenses for a new clinical nurse specialist program being established by your healthcare organization. The nurses would provide education while patients are in the hospital and home visits are on a fee-for-service basis after patients have been discharged Should the hospital undertake the program if its required rate of return is 12%? Note: it must be assumed that the revenues and costs in this problem represent cash flows. Present value analysis is based on cash, not revenue or expenses. Provide a response to support the findings in the table listed below. Your response should be at least a half page long in addition to the table. Please include citations. Year One Year Two Year Three Year Four Total Revenue $100,000 $150,000 $200,000 $250,000 $700,000 Costs $150,000 $150,000 $150,000 $150,000 $600,000 $ <50,000> $0 $50,000 $100,000…
In this part of the project, you will be purchasing the home you chose in the Budget Project. You will need to obtain a loan from a financial institution since you cannot pay cash for your home. You will be researching three different loan scenarios and determining which loan option best fits your situation and needs. Purchase price of the home you chose from the Budget Project: ________$431,873______ Part 1: Financing your home Loan Scenario 1: In this scenario, your financial institution is offering you a 30-year fixed mortgage with a 20% down payment at a 3.43% fixed rate. Determine the following: Calculate the down payment for this loan. How much will you need to finance from the bank for this loan? What is your monthly payment? Use technology or the monthly payment formula in your text to get the monthly payment for this loan. What is the total cost of the loan over 30 years? How much of this cost is interest? What is the total you will expect to pay at closing for this loan…
Use a financial calculator or computer software program to answer the following questions: a) Melanie is trying to save money for retirement and has a future goal of $750,000 at the end of 20 years. Determine the present value of her goal using a discount rate of 12%. b) How would the present value change if the $750,000 is to be received at the end of 15 years instead? Explain the impact and show your work?
Jamie Lee and Ross agree that by accomplishing their short goals, they can budget $5,000 a year towards their long-term investment goals. They are estimating that with the allocations recommended by their financial advisor, they will see an average of 7 percent on their investments. The triplets will begin college in 15 years and will need $100,000 for tuition. Using the Time Value of Money calculations, decide if Jamie Lee and Ross will be on track to reaching their long-term financial goals of having enough money from their investments to pay the triplets’ tuition.