I need help and I do not know where to start. I have attached the assignment I am working on had 15 questions and I am scared I will not bet it done before tomorrow morning.

Problem 5.33 Future Value You have $12,000 in cash. You can deposit it today in a mutual fund earning 8.2 percent semiannually, or you can wait, enjoy some of it, and invest $11,000 in your brother's business in two years. Your brother is promising you a return of at least 10 percent on your investment. Whichever alternative you choose, you will need to cash in at the end of 10 years. Assume your brother is trustworthy and both investments carry the same risk. Which one will you choose? Hint: Determine the future value of each option at the indicated interest rate and time period. Create a solution using time value of money equations and then use the FV financial function to solve: FV(rate,nper,pmt,pv,type). Make sure that all cells are properly formatted. The frequency of compounding periods per year is denoted by "m." Option A: Enter: Enter: Enter: Enter: Results (equation): Results (FV function): Mutual Fund N= 10 I= 8.20% PV = $12,000.00 m= 1 FV10 = FV10 = Option B: Enter: Enter: Enter: Enter: Result: Result: Brother's Business N= 8 I= 10.00% PV = $11,000.00 m= 1 FV10 = FV10 = Given the analysis above, the best alternative is to invest in the Better off with opiton A The better alternative yields an additional Problem 5.34 Future Value When you were born your parents set up a bank account in your name when you were born with an initial investment of $5,000. You are turning 21in a few days and will have access to all ypur funds. The account was earning 7.3 percent for the first seven years, but then the rates went down to 5.5 percent for six years. The economy was doing well in the early 2000's, and your account was earning 8.2 percent three years in a row. Unfortunately, the next two years you earned only 4.6 percent. Finally, as the economy recovered, your return jumped to 7.6 percent for the last three years. a. How much money was in your account before the rates went down drastically (end of year 16)? Hint: Determine the future value of the initial investment for each period at the indicated rate of interest. The future value determined at each stage becomes the present value for the following period. Create a solution using time value of money equations and then use the FV financial function to solve: FV(rate,nper,pmt,pv,type). Make sure that all cells are properly formatted. Enter: Enter: Enter: Stage 1 N= I= PV = Results (equation): Results (FV function): FV7 = FV7 = Enter: Enter: Enter: Stage 2 N= I= PV = Enter: Enter: Enter: Stage 3 N= I= PV = Result: Result: FV13 = FV13 = Result: Result: FV16 = FV16 = b. How much money is in your account now (end of year 21)? Hint: Using the result from Stage 3, determine the future values for Stage 4 and 5 at the indicated rates of interest. Follow the procedure set forth in Part (a). Stage 4 Stage 5 Enter: N= Enter: N= Enter: I= Enter: I= Enter: PV = Enter: PV = Results (equation): Results (FV function): FV18 = FV18 = Result: Result: FV21 = FV21 = c. What would be the balance now if your parents made another deposit of $1,200 at the end of year 7? Hint: Add $1,200 to the result from Stage 1 and enter this value as the PV for Stage 2. Continue through Stage 5 to obtain the final answer. Stage 2 Stage 3 Enter: N= Enter: N= I= I= Enter: Enter: Enter: PV = Enter: PV = Results (equation): Results (FV function): FV13 = FV13 = Result: Result: FV16 = FV16 = Enter: Enter: Enter: Stage 4 N= I= PV = Enter: Enter: Enter: Stage 5 N= I= PV = Results (equation): Results (FV function): FV18 = FV18 = Result: Result: FV21 = FV21 = Problem 5.35 Present Value Sam Bradford, a number 1 draft pick of the St. Louis Rams, and his agent are evaluating three contract options. Each option ofers a signing bonus and a series of payments over the life of the contract. Bradford uses a 10.25 percent rate of return to evaluate the contracts. contracts. Given the cash flows for each option, which one should he choose? Year 0 1 2 3 4 5 6 Cash Flow Type Signing Bonus Annual Salary Annual Salary Annual Salary Annual Salary Annual Salary Annual Salary Option A Option B Option C $3,100,000 $4,000,000 $4,250,000 $650,000 $825,000 $550,000 $715,000 $850,000 $625,000 $822,250 $925,000 $800,000 $975,000 $1,250,000 $900,000 $1,100,000 $1,000,000 $1,250,000 Hint: Determine the present value of each option and compare. Create a solution using time value of money equations and then use the NPV financial function to solve: NPV(rate,value1,value2, ...). Make sure that all cells are properly formatted. Enter: Enter: Enter: Enter: Enter: Enter: Enter: Option A CF0 = CF1 = CF2 = CF3 = CF4 = CF5 = CF6 = Enter: Enter: Enter: Enter: Enter: Option B CF0 = CF1 = CF2 = CF3 = CF4 = Option C CF0 = CF1 = CF2 = CF3 = CF4 = CF5 = Enter: Enter: Enter: Enter: Enter: Enter: Enter: I= Enter: I= Enter: I= Results (equation): Results (NPV function): PV0 = PV0 = Result: PV0 = Result: PV0 = Given the analysis above, the best alternative for Mr. Benson is . Problem 5.36 Time to Attain Goal Surmec, Inc. reported earnings of $2.1 million last year. The company's primary business line is manufacturing of nuts and bolts. Since this is a mature industry, analysts are confident that the sales will grow at a steady rate of 7 percent a year. The company's net income equals 23 percent of sales. Management would like to buy a new fleet of trucks but can only do so once the profit reaches $620,000 a year. At the end of what year will they be able to buy the trucks? Hint: Determine the current level of net income based upon the information given. Create a solution that illustrates how long it will take for this current level of income to grow to the target profit level, first using time value of money equations and then the NPER financial function: NPER(rate,pmt,pv,fv,type). Make sure that all cells are properly formatted. Current sales level: Profit margin: Current net income: Target profit level: Projected growth rate of sales: Result in years (equation): Result in years (NPER function): The company will achieve its profit target during year What will the sales and net income be in that year? Hint: Find the level of sales for the year in which the profit level is reached and then use this sales figure to compute the profit level. Current sales level: Projected growth rate of sales: Target profit year: Target year sales (equation): Target year sales (FV function): Target year profit: Problem 5.37 Interest Rate You will be graduating in two years and are thinking about your future. You know that you will want to buy a house five years after you graduate and that you will want to put down $60,000. As of right now, you have $8,000 in your savings account. You are also fairly certain that once you graduate, you can work in the family business and earn $32,000 a year, with a 5 percent raise every year. You plan to live with your parents for the first two years after graduation, which will enable you to minimize your expenses and put away $10,000 each year. The next three years, you will have to live out on your own, as your younger sister will be graduating from college and has already announced her plan to move back in the family house. Thus, you will only be able to save 13 percent of your annual salary. Assume that you will be able to invest savings from your salary at 7.2 percent. At what interest rate will you need to invest the current savings account balance in order to achieve your goal? Hint: Draw a timeline that shows all the cash flows for years 0 through 7. Remember, you want to buy a house seven years from now and your first salary will be in year three. First compute the salary levels and then the amount of money saved each year. Next, calculate the remaining amount needed to reach the goal. The final step involves solving for the rate of return required for the current savings balance to grow to the amount calculated in the previous step. Use both time value of money equations and as well as the FV financial function: FV(rate,nper,pmt,pv,type), the NPV function: NPV(rate,value1,value2, ...), and the RATE function: RATE(nper,pmt,pv,fv,type,guess). Make sure that all cells are properly formatted. Starting salary in year 3: Annual pay increase: Savings in first 2 years: Savings rate for years 3 - 7: Year Salary Savings 1 2 3 Investment rate: Future value of savings from salary (equation): Future value of savings from salary (function): Target down payment: Target shortfall: Current savings balance: Time to achieve target (years): Result (equation): Result (function): 4 5 6 7