I am have difficulty figuring out what Im doing wrong. I have gotten 1/4 of the way there. The rest of the assignment I dont know where to start. My forumlas on the bond worksheet, dont add either. I know I did something wrong there. PLEASE HELP ASAP! At the moment I am only working on Chapter 5 Case one. I will need to work on Chapter 4 Case 1(no template given) as well. If you have any insights on chapter 4 that would be great too!

Kelly's Boutique Loan Amortization Schedule Loan Amount Loan Term Rate Payment $300,000 5 3.0% $65,506.37 Payment # Payment Interest Principal 1 2 3 4 5 Total $65,506.37 $65,506.37 $65,506.37 $65,506.37 $65,506.37 $9,000 $7,305 $5,559 $3,760 $1,908 $56,506.37 $58,201.56 $59,947.61 $61,746.04 $63,598.42 Student Name 05/31/2016 qattachments_3ab4ef4fb6b801067c4bb7375394683a9e3714c7.xlsx Balance $300,000 $243,493.63 $185,292.07 $125,344.46 $63,598.42 $0.00 Student Name 05/31/2016 qattachments_3ab4ef4fb6b801067c4bb7375394683a9e3714c7.xlsx Kelly's Boutique Bond Amortization Schedule Market Rate Stated Rate Interest Payment Bond Term Face Value Proceeds (Discount) / Premium Payment # 1 2 3 4 5 Totals Student Name 05/31/2016 2.9% 3% 9000 5 300,000 $301,377.84 $1,377.84 Interest Payment 9000 9000 9000 9000 9000 Interest Expense Amortization $8,739.96 $8,772.37 $65.77 ($233.28) #VALUE! $260.04 $227.63 $8,934.23 $9,233.28 #VALUE! (Discount) Carrying Premium Value $1,377.84 ### $1,117.80 ### $890.18 $2,268.02 ($8,044.05) ($8,044.05) ### #VALUE! #VALUE! #VALUE! qattachments_3ab4ef4fb6b801067c4bb7375394683a9e3714c7.xlsx Chapter 5 Case Problem 1: KELLY'S BOUTIQUE Kelly's Boutique is contemplating several alternative means of financing an expansion. One alternative is to borrow $300,000 from a local bank; another alternative is to borrow this amount from investors by issuing bonds. Both alternatives involve a 5-year debt period. Modify the workbook file ch5-05 to compute a loan and bond analysis. Name and format cell ranges as appropriate. Assume an initial loan rate of 3 percent, an initial bond stated rate of 3 percent, and a market interest rate of 2.9 percent. a. Print the newly completed loan and bond worksheets in Value view, with your name and date printed in the lower left footer and the file name in the lower right footer. b. Print the worksheets from part a (above) in Formula view, with your name and date printed in the lower left footer and the file name in the lower right footer. c. Use the Scenario Manager to create two loan scenarios called Best Case and Worst Case. In the Best Case, the rate would be 2.8 percent and the loan amount would be $325,000; in the Worst Case, the rate would be 3.2 percent and the loan amount would be $280,000. (Hint: You'll need to place two cell references, separated by a comma, in the Changing cells: text box.) The resulting comparison values you're trying to predict are Payment, Total Payments, and Total Interest. Print the resulting summary worksheet. d. Use the Scenario Manager to create two bond scenarios called Best Case and Worst Case. In the Best Case, the market rate would be 2.5 percent and the stated rate would be 2 percent; in the Worst Case, the market rate would be 3.2 percent and the stated rate would be 3.1 percent. (Again, you'll need to place two cell references, separated by a comma, in the Changing cells: text box.) The resulting comparison values you're trying to predict are Proceeds, Total Interest Payments, and Total Interest Expense. Print the resulting summary worksheet. e. Use Excel's goal seek feature to calculate the interest rate that the company would have to negotiate under the original loan analysis (in part a) to achieve a payment of $63,000. Round the interest rate to two decimal places. Print the resulting worksheet in Value view, with your name and date printed in the lower left footer and the file name in the lower right footer. f. Use Excel's goal seek feature to calculate the market rate necessary to achieve bond proceeds of $310,000. Round the interest rate to two decimal places. Print the resulting worksheet in Value view, with your name and date printed in the lower left footer and the file name in the lower right footer. Chapter 4 Case Problem 1: KELLY'S BOUTIQUE Kelly's Boutique owned the following fixed assets as of December 31, 2015: Description Asset # 101 102 103 Asset Building Computer System Phone System Date acquired 1/1/12 1/1/14 1/1/14 Cost $700,000 $75,000 $96,500 Salvage value $22,000 $2,000 $6,000 Estimated useful life 25 years 4 years 5 years You are to create a fixed asset depreciation summary and individual depreciation worksheets for Kelly's Boutique using the straight-line depreciation method based on the information tabulated above. Be sure to pay close attention to the date of purchase for each asset so that your summary sheet is correct. The summary sheet need only include depreciation from 2012 through 2015. Individual assets must show depreciation over their entire useful life. Follow the text examples for formatting. Label your worksheets as follows: Summary SL, Asset 101 SL, Asset 102 SL, and Asset 103 SL. In the same workbook, create Kelly's Boutique's fixed asset depreciation summary and individual depreciation worksheets using the double declining balance method and based on the tabulated information. Again, pay close attention to the date of purchase for each asset so that your summary sheet is correct. Label your worksheets: Summary DDB, Asset 101 DDB, Asset 102 DDB, and Asset 103 DDB. In the same workbook, next create Kelly's Boutique's fixed asset depreciation summary and individual depreciation worksheets using the sum-of-the-year's digits method and based on the tabulated information. Pay close attention to the date of purchase for each asset so that your summary sheet is correct. Label your worksheets: Summary SYD, Asset 101 SYD, Asset 102 SYD, and Asset 103 SYD. In the same workbook, you should now create a chart of Asset 101's depreciation (over its 25-year estimated useful life) that compares the straight-line, double declining balance, and sum-of-the-year's digits methods of calculating depreciation. Label this worksheet: Chart. Choose any 2D line chart and chart layout that you like. Save the workbook as ch4-03_student_name (replacing student_name with your name). Print all worksheets in Value view, with your name and date printed in the lower left footer and the file name in the lower right footer. Name Asset # Asset # Date Aquired Cost Depreciation method Salvage Value Estimated useful Life Year Depreciation Expense Accumulated Depreciation Name Equiptment Depreciation Summary Asset Total Date Aquired Cost Depreciation Method (Year) Depreciation (Year) Acc Deprec. (Year) Depreciation (Year) Acc Depreciation