Complete the following problems (attached in a word document below):

1. P5-2
2. P5-6
3. P5-14
4. P5-22
5. P5-29
6. P5-39

Follow these instructions for completing and submitting your assignment:

1. Do all work in Excel. Do not submit Word files or *.pdf files.
2. Submit a single spreadsheet file for this assignment. Do not submit multiple files.
3. Place each problem on a separate spreadsheet tab.
4. Label all inputs and outputs and highlight your final answer.
5. Follow the directions in ?Guidelines for Developing Spreadsheets.?

You are not required to submit this assignment to Turnitin.

Guidelines for Developing Spreadsheets It is important to develop spreadsheets that are clear, well-organized, and easy to read. Here are some tips that you will need to assist with your assignments in class. I recommend them for all your work, both at GCU and later in your career. 1. 2. 3. 4. 5. Your spreadsheet should be organized into three basic parts. Clearly label each part. a. A title, labeling what your spreadsheet does. The title for your spreadsheets in this course can be the problem number that you are assigned. Place this in the upper left corner, in cell A1. b. Inputs, which are given or assumed. c. Results (Outputs) which the spreadsheet calculates. Provide specific labels for all inputs and outputs. Label both the variable names and the notation for the variables. Where a formula is involved, it is a good idea (but not necessary) to enter the formula to the right of the cell containing the results. I display these formulas in italics, so that they are not confused with the variable labels. Highlight the cell containing the final answer, using EXCEL's yellow highlighter, which can be found on the top menu bar. If your spreadsheet uses a long formula, you might find it advisable to break the formula into component parts. This serves to minimize the typos that can occur when entering long formulas, as well as makes locating errors in the results easier to find. Nested parentheses are a particular problem in long formulas, and breaking up the calculations into component parts minimizes the need for nested parentheses also. In the example below, the calculations are broken into two steps; (1) the percentage changes in price and quantity demanded, and (2) the final elasticity calculation using these intermediate results. Don't forget to place each homework problem on a separate spreadsheet tab. Label these tabs with the problem number for easy identification. A sample spreadsheet reflecting these points is below. Calculating Price Elasticity of Demand Inputs: Original Price (P1) New Price (P2) Original Quantity Sold (Q1) New Quantity Sold (Q2) $10.00 $12.00 950 900 Results: % change in price (decimal form) % change in quantity demanded (decimal form) price elasticity of demand 0.2000 -0.05263 -0.26316 =(p2-p1)/p1 =(q2-q1)/q1 Do not submit: 1. Word files 2. Multiple files for a single assignment 3. Filenames that start with anything but your last name. Save your files as Smith module 1 hmwk.xlsx 4. Filenames that do not have the module number on them 2014. Grand Canyon University. All Rights Reserved. 2014. Grand Canyon University. All Rights Reserved. P5-2 Future value calculation Without referring to the preprogrammed function on your financial calculator, use the basic formula for future value along with the given interest rate, r, and the number of periods, n, to calculate the future value of $1 in each of the cases shown in the following table. P5-6 Time value As part of your financial planning, you wish to purchase a new car exactly 5 years from today. The car you wish to purchase costs $14,000 today, and your research indicates that its price will increase by 2% to 4% per year over the next 5 years. a. Estimate the price of the car at the end of 5 years if inflation is (1) 2% per year and (2) 4% per year. b. How much more expensive will the car be if the rate of inflation is 4% rather than 2%? c. Estimate the price of the car if inflation is 2% for the next 2 years and 4% for 3 years after that. P5-14 Time value An Iowa state savings bond can be converted to $100 at maturity 6 years from purchase. If the state bonds are to be competitive with U.S. savings bonds, which pay 8% annual interest (compounded annually), at what price must the state sell its bonds? Assume no cash payments on savings bonds prior to redemption. P5-22 Retirement planning Hal Thomas, a 25-year-old college graduate, wishes to retire at age 65. To supplement other sources of retirement income, he can deposit $2,000 each year into a tax-deferred individual retirement arrangement (IRA). The IRA will earn a 10% return over the next 40 years. a. If Hal makes annual end-of-year $2,000 deposits into the IRA, how much will he have accumulated by the end of his sixty-fifth year? b. If Hal decides to wait until age 35 to begin making annual end-of-year $2,000 deposits into the IRA, how much will he have accumulated by the end of his sixty-fifth year? c. Using your findings in parts a and b, discuss the impact of delaying making deposits into the IRA for 10 years (age 25 to age 35) on the amount accumulated by the end of Hal's sixty-fifth year. d. Rework parts a, b, and c, assuming that Hal makes all deposits at the beginning, rather than the end, of each year. Discuss the effect of beginning-of-year deposits on the future value accumulated by the end of Hal's sixty-fifth year. P5-29 Value of a single amount versus a mixed stream Gina Vitale has just contracted to sell a small parcel of land that she inherited a few years ago. The buyer is willing to pay $24,000 at the closing of the transaction or will pay the amounts shown in the following table at the beginning of each of the next 5 years. Because Gina doesn't really need the money today, she plans to let it accumulate in an account that earns 7% annual interest. Given her desire to buy a house at the end of 5 years after closing on the sale of the lot, she decides to choose the payment alternative$24,000 single amount or the mixed stream of payments in the following tablethat provides the higher future value at the end of 5 years. Which alternative will she choose? P5-39 Compounding frequency and time value You plan to invest $2,000 in an individual retirement arrangement (IRA) today at a nominal annual rate of 8%, which is expected to apply to all future years. a. How much will you have in the account at the end of 10 years if interest is compounded (1) annually, (2) semiannually, (3) daily (assume a 365-day year), and (4) continuously? b. What is the effective annual rate (EAR) for each compounding period in part a? c. How much greater will your IRA balance be at the end of 10 years if interest is compounded continuously rather than annually? d. How does the compounding frequency affect the future value and effective annual rate for a given deposit? Explain in terms of your findings in parts a through c