PLEASE ANSWER IN EXCEL: I have attached a Google Drive link to an Excel workbook. The file includes an Example sheet that shows exactly how each question should be answered in Excel. Please follow that format for every assigned question.

Use the Example sheet as the model. Keep it unchanged.

For each question, create a new sheet and label it with the chapter and problem number, for example Ch2_P1, Ch2_P2, Ch4_P8, Ch4_P12. You may also use "Chapter 2 - Problem 1" if you prefer words.

On every sheet include three sections: Inputs, Calculations, and Final Answer.

Use cell formulas for all calculations. Do not hard type final numbers.

Clearly label units and round currency to two decimals.

When finished, keep all sheets in the same workbook and return the completed file to me via the Google Drive link.

CHAPTER 5: PROBLEM 7, 11 7. Future value with periodic rates. Matt Johnson delivers newspapers and is putting away $15.00 every month from his paper route collections. Matt is eight years old and will use the money when he goes to college in ten years. What will be the value of Matt's account in ten years with his monthly payments if he is earning 6% APR, 8% APR, or 12% APR?

11. Amortization schedule with periodic payments. Moulton Motors is advertising the following deal on a new Honda Civic: "Monthly payments of $400.40 for the next 60 months and this beauty can be yours!" The sticker price of the car is $18,000. If you bought the car, what interest rate would you be paying in both APR and EAR terms? What is the amortization schedule of these sixty payments?

CHAPTER 6: PROBLEM 1, 4 Bond prices. For Problems 1 through 4, use the information in the following table.

PROBLEM 1

Par Value	Coupon Rate	Years to Maturity	Yield to Maturity	Price
$1,000.00	8%	10	6%	?
$1,000.00	6%	10	8%	?
$5,000.00	9%	20	7%	?
$5,000.00	12%	30	5%	?

1. Price the bonds from the table with annual coupon payments.

2. Price the bonds from the table with semiannual coupon payments.

3. Price the bonds from the table with quarterly coupon payments.

4. Price the bonds from the table with monthly coupon payments.

CHAPTER 7: PROBLEM 1, 2, 3

These problems are available in MyLab Finance.

Stock price. Anderson Motors, Inc. has just set the company dividend policy at $0.50 per year. The company plans to be in business forever. What is the price of this stock if an investor wants

a 5% return?

an 8% return?

a 10% return?

a 13% return?

a 20% return?

Stock price. Dietterich Electronics wants its shareholders to earn a 15% return on their investment in the company. What would the price of the stock need to be today if Dietterich Electronics had a

$0.25 constant annual dividend forever?

$1.00 constant annual dividend forever?

$1.75 constant annual dividend forever?

$2.50 constant annual dividend forever?

Stock price. Singing Fish Fine Foods has a current annual cash dividend policy of $2.25. The price of the stock is set to yield a 12% return. What is the price of this stock if the dividend will be paid

for 10 years?

for 15 years?

for 40 years?

for 60 years?

for 100 years?

forever?

https://docs.google.com/spreadsheets/d/12HVLq2t0_1KDMM1GNznUBmtPHHbmpKt0/edit?usp=share_link&ouid=103193960533208000015&rtpof=true&sd=true