James's New Year’s resolution (Graded A+) - use as a guide only - 27594

Solution Posted by

arsalanahmed

Rating : (80)A
Solution Detail
Price: \$12.00
• From: Finance,
• Posted on: Fri 04 Oct, 2013
• Request id: None
• Purchased: 0 time(s)
• Average Rating: No rating
Request Description

1.       James's New Year’s resolution is to start a retirement fund.  He has opened an account with a local broker by depositing \$5000 in an investment fund.  In the future he plans to invest \$2,000 annually into the fund.

a.       If the index funds averages a return of 9% annually (EAR), what will he have available for retirement after 30 years?

b.      If James wants a retirement fund of \$500,000 when he retires, how many years will he have to work?

2.       Sandra is evaluating her retirement plan.  Suppose she has \$500,000 when she retires in an account that earns at an effective annual rate of 9%.

a.       If Sandra withdraws \$75,000 annually, how long will her funds last?

b.      To make the funds last 25 years, how much can Sandra withdraw annually?

c.       Sandra is considering a two phase withdrawal where she withdraws \$60,000 annually for 10 years, and then \$35,000 thereafter (when social security starts).   How long will her funds last assuming that the 9% rate of return (EAR) is accurate for both phases of the retirement plan.

3.       Penny gets paid every other week (bi-weekly) and her husband Patrick gets paid monthly.  Penny is going to make a \$150 deposit from her paycheck every two weeks into a new retirement fund, and Patrick is going to deposit \$300 from his paycheck monthly into a new retirement fund.  Both accounts earn an effective annual rate of 6%.  Penny's account compounds bi-weekly and Patrick's fund compounds monthly that matches their deposits.

a.       What together can Penny and Patrick expect to receive from their deposits in 30 years?

b.      How much would Patrick have to deposit each month for the combined savings to achieve \$1 million in thirty years?  (Penny would continue as above.)

4.       Sam is going to buy a new car costing \$24,000.  Wealthy Uncle Job offered a choice of three loans as described below.   The annual percentage rate with monthly compounding for all three alternative loans would be 3.25% and the loans would be for 4 years.  Determine the payment amount that Sam would have to make for each loan alternative?

a.       Loan 1 would be for the total cost of the car and Sam would pay equal monthly payments to Uncle Job.

b.      Loan 2 would be for the total cost of the car with Sam making a \$3,000 payment at the end of the loan and equal annual payments to Uncle Job for the remainder.

c.       Loan 3 would have Sam using \$3000 of his personal savings upfront to reduce the loan size and Sam would make equal monthly payments to Uncle Job.

5.       Pat Davis has earned a promotion that will pay an annual bonus of \$10,000 at the end of the first year and increase by 12% each year thereafter.  He is going to deposit his annual bonus into a fund that has an annual percentage rate of 5% compounded monthly that presently has \$30,000 in it. He plans to retire in 15 years.  How much will be in the fund at the time he retires?

6.       Jimmy took out a 30 year fixed home mortgage for \$400,000 five years ago with a rate of 5.5% APR with monthly compounding.  He can get a new loan at 4% APR compounded monthly if he takes \$25,000 out of his investment fund  that presently earn 8% APR compounded monthly.  The \$25,000 is needed to reduce the size of the new loan since the value of the home has diminished due to the Great Recession, and also to pay a \$500 processing fee.  If this new mortgage is a 25 year fixed rate at 4% APR compounded monthly, determine how much Jimmy would save monthly, if any.

7.       Jamie is applying for a business loan of \$500,000 for her company to expand her Internet sales.   The bank has asked for an Income statement and Cash Flow statement for the upcoming three years (called "pro forma" statements).  Below is the data that she has put together based on the past statements and her plans for the future.

a.       Prepare an income statements  with three columns of data for the years 2013, 2104,  and 2015 that includes totals for Gross margin, SG&A, EBIT, Pre-tax Income and Net Income.

b.      Prepare a cash flow statement with three columns of data for the years 2013, 2014 and 2015 that includes rows for the cash on hand at the beginning of each year, and at the end of each year.

ØCash on Hand EOY 2012                 \$100,000.00

 Items 2013 2014 2015 Asset purchases \$450,000 \$150,000 \$150,000 Depreciation \$65,000 \$80,000 \$100,000 Office Equipment rental \$5,000 \$5,000 \$5,000 Hourly wages \$300,000 \$350,000 \$400,000 Loan Principal Paid \$100,000 \$100,000 \$100,000 Interest Paid \$40,000 \$35,000 \$30,000 Marketing and Web site \$115,000 \$150,000 \$170,000 Miscellaneous expenses \$260,000 \$300,000 \$350,000 Permanent Staff Salaries \$200,000 \$250,000 \$300,000 Rent \$13,700 \$15,000 \$16,500 Sales \$1,000,000 \$1,500,000 \$1,750,000 Tax Rate 20% 20% 20%

low?? g?? ??? emand (AD) and short-run aggregate supply (SRAS) schedules. Decision-makers have previously made decisions anticipating that the price level during the current period will be P105.

a.       Indicate the quantity of GDP that will be produced during the period.

b.      Is it a long-run equilibrium level of GDP? Why or why not?

c.       How will the unemployment rate during the current period compare with the natural rate of             unemployment?

d.      Will the current rate of GDP be sustainable into the future? Why or why not?

 AD 105 Price Level SRAS 105 6300 90 4500 6000 95 4800 5700 100 5100 5400 105 5400 5100 110 5700 4800 115 6000

This assignment is due by 11:59 p.m. (ET) on Monday of Module/Week 2.

Solution Description

A++++++++++

Attachments