The questions are attached. All worksheets should be complied within one Excel workbook. Thank you.

Rosey's Roses Inventory Type Shrub Shrub Shrub Shrub Shrub Shrub Shrub Shrub Climber Climber Tree Tree Tree Description Abraham Darby #5 Be My Baby #5 Deja Blu #5 Koko Loko #7 Peach Drift #10 Red Drift #10 Sedona #5 Sweet Intoxication #5 Climbing Orange Crush #7 Don Juan Climber #5 Barbara Streisand 36in Tree Firefighter 36in Tree Trumpteter 36in Tree Rosey's Roses Income Statement for the period ended Sales Less: Cost of Goods Sold Gross Margin Expenses: Advertising Communications Depreciation Payroll Rent Supplies Utilities Net income 12/31/2013 $ 175,000 85,000 90,000 $ 18,000 7,500 5,000 32,000 12,000 700 4,600 12/31/2014 $ 200,000 105,000 95,000 $ $ 79,800 10,200 17,000 6,500 5,000 36,000 13,000 800 4,000 $ 82,300 12,700 Rosey's Roses Balance Sheet as of 12/31/2013 Assets Current Assets: Cash Accounts Receivable Inventory Supplies Buildings Equipment Less: Accumulated Depreciation Total Liabilities and Stockholders' Equity Current Liabilities Accounts Payable Payroll Liabilities Long-Term Debt Owner's Equity Total 15,000.00 21,248.18 11,001.82 250.00 55,000.00 7,500.00 10,000.00 22,500.00 4,500.00 47,500.00 52,500.00 100,000.00 27,000.00 12/31/2014 15,000.00 18,373.97 8,626.03 500.00 75,000.00 7,500.00 15,000.00 25,000.00 5,000.00 42,500.00 67,500.00 110,000.00 30,000.00 70,000.00 64,300.00 3,000.00 100,000.00 15,700.00 110,000.00 Rosey's Roses Ratio Analysis December 2014 Profitability Return on owners' investment Return on total investment Profit margin Gross margin Liquidity Current ratio Quick ratio Receivable turnover Inventory turnover Solvency Debt-to-equity Liability Rosey's Roses Loan Amortization Schedule Loan Amount Rate Loan Term Payment Pmt. # 1 2 3 4 5 6 7 8 9 10 Totals Payment Interest Principal Balance Rosey's Roses Bond Amortization Schedule Market Rate Stated Rate Face Value Bond Term Interest Payment Proceeds (Discount) / Premium Payment # 1 2 3 4 5 6 7 8 9 10 Totals Interest Payment Interest Expense Amortization (Discount) Premium Carrying Value Rosey's Roses Cash Budget Operating activities Operating cash receipts Product sales revenue Collections in the year of sale Collections in the year following sale Operating cash receipts Operating cash payments Purchases Cost of expected sales Required ending inventory Beginning inventory Purchases Payments in the year of purchase Payments in the year following purchase Cash payments for purchases Expenses Advertising expense Interest expense Wages expense Supplies expense Utilities expense Expenses Operating cash payments Cash from (to) operating activities Investing activities Equipment purchases Equipment sales Cash from (to) investing activities Financing activities Loan proceeds Loan payments Cash from (to) financing activities Change in cash Beginning cash Ending cash Assumptions Sales growth each year Expense growth each year Collections in the year of sale Collections in the year following sale Payments in the year of purchase Payments in the year following purchase Cost of expected sales Required ending inventory Beginning inventory Interest expense Loan proceeds Annual loan payment Annual equipment purchases Annual equipment sales Year 1 equipment purchase Prior Year 150,000 127,500 16,000 143,500 90,000 20,700 (18,000) 92,700 83,430 6,000 89,430 15,000 20,000 1,000 3,300 39,300 128,730 14,770 14,770 5,430 20,200 1 2 3 Here are the sections to the problems (They have excel templates except for Chapter 4's problem) 1) Chapter 2 Case Problem 4: ROSEY'S ROSES / / / / / / / / / / Rosey's Roses is located in Savannah, Georgia, and specializes in the sale of roses. You, as the manager of the business, are curious to see how Excel might help you manage the business and account for its inventory. To that end, you have hired a local college student to construct several worksheets to help the business better understand the financial and managerial aspects of the company. To begin, the two of you decide to create a worksheet of Rosey's inventory. Start with worksheet ch2-08 and make the following changes: 1 Format the company name and worksheet title bold and italics. 2 Move the company name and worksheet title from column C to column A. 3 Format the title of each column (located in row 4) bold with a bottom border. 4 Add a column (titled Quantity) to the right of column Description. 5 Format the Quantity title aligned centered, bold with a bottom border. 6 Format the values under the Quantity title as comma style with no decimals. 7 Resize column C to 95 pixels. 8 Add an additional column (titled Cost/Unit) to the right of column Quantity. 9 Format the Cost/Unit title aligned centered, bold with a bottom border. 10 Format the values under the Cost/Unit title as / / / / / / / currency. 11 Resize column D to 115 pixels. 12 Add an additional column (titled Cost) to the right of column Cost/Unit. 13 Format the Cost title aligned centered, bold with a bottom border. 14 Format the values under the Cost title as currency. 15 Resize column E to 115 pixels. 16 Enter the following values for Quantity and Cost/unit Type Description Shrub Abraham Darby #5 Shrub Be My Baby #5 Shrub Deja Blu #5 Shrub Koko Loko #7 Shrub Peach Drift #10 Shrub Red Drift #10 Shrub Sedona #5 Shrub Sweet Intoxication #5 Climber / / / / / / Climber Tree Tree Tree Quan 25 30 18 17 33 15 3 17 Climbing Orange Crush #7 16 Don Juan Climber #5 25 Barbara Streisand 36in Tree Firefighter 36in Tree Trumpeter 36in Tree 50 14 4 17 Insert a formula to calculate the cost as quantity times cost/unit in cell E5. 18 Format this cell aligned right. 19 Fill down this formula for all cells in the table. 20 Insert a row below the last shrub listed. 21 Add one additional item into your newly added / / / / row with a type \"Shrub,\" description \"Wing Ding #5,\" quantity \"30,\" and cost/unit \"11.99.\" 22 Type Total in cell A20. 23 Insert a formula to calculate the total cost of all roses into cell E20. 24 Format cell E20 to align right with a top and double bottom border. 25 Save the file as ch2-08_student_name (replacing student_name with your name). 26 Print the completed worksheet in Value view, with portrait orientation with your name and date printed in the lower left footer and file name in the lower right footer. 2) Chapter 3 Case Problem 4: ROSEY's ROSES You are to create a financial analysis for Rosey's Roses as of December 31, 2013, and December 31, 2014. Following the Chapter 3 examples, use the student file ch3-07.xls to create a vertical analysis of the balance sheet and income statement as of December 31, 2013, and December 31, 2014as well as a horizontal analysis of both the income statement and balance sheet comparing December 31, 2013, with December 31, 2014. Place the vertical analysis in columns D and G on the income statement labeled % of Sales in cells D5 and G5. Place the vertical analysis in columns D and G on the balance sheet labeled % of Assets in cells D5 and G5. Place the horizontal analysis in column I labeled % Change in cell I5 for both the income statement and balance sheet. Also create a pie chart of expenses for the year ended December 31, 2014, formatted in a manner similar to your chapter work; a column chart of expenses for the years ended December 31, 2013, and December 31, 2014, formatted in a manner similar to your chapter work; and a ratio analysis as of December 31, 2014. Note: You will have to use Excel's help feature to create the column chart, because the columns are not adjacent to one another as in the chapter example. Use whatever chart layout you prefer. Save the workbook as ch3-07_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. 3) Chapter 3 Case Problem 4: ROSEY's ROSES You are to create a financial analysis for Rosey's Roses as of December 31, 2013, and December 31, 2014. Following the Chapter 3 examples, use the student file ch3-07.xls to create a vertical analysis of the balance sheet and income statement as of December 31, 2013, and December 31, 2014as well as a horizontal analysis of both the income statement and balance sheet comparing December 31, 2013, with December 31, 2014. Place the vertical analysis in columns D and G on the income statement labeled % of Sales in cells D5 and G5. Place the vertical analysis in columns D and G on the balance sheet labeled % of Assets in cells D5 and G5. Place the horizontal analysis in column I labeled % Change in cell I5 for both the income statement and balance sheet. Also create a pie chart of expenses for the year ended December 31, 2014, formatted in a manner similar to your chapter work; a column chart of expenses for the years ended December 31, 2013, and December 31, 2014, formatted in a manner similar to your chapter work; and a ratio analysis as of December 31, 2014. Note: You will have to use Excel's help feature to create the column chart, because the columns are not adjacent to one another as in the chapter example. Use whatever chart layout you prefer. Save the workbook as ch3-07_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. 4) Chapter 4 Case Problem 4: ROSEY'S ROSES Rosey's Roses owned the fixed assets shown below as of December 31, 2014: Asset Building #1 Building #2 Date acquired 1/1/13 1/1/14 Cost $55,000 $20,000 Salvage value $4,000 $1,000 Estimated useful life 15 years 5 years This assignment has no beginning student file. You are to create Rosey's fixed asset depreciation worksheets from a blank worksheet using the straight-line depreciation method and based on the information in the preceding table. No summary sheet is required. Individual assets must show depreciation over their entire useful life. Follow the text examples for formatting. Label each worksheet Building #1 SL, Building #2 SL, and Equipment SL. In the same workbook, create Rosey's fixed asset depreciation worksheets using the double declining balance method and based on the same table. No summary sheet is required. Individual assets must show depreciation over their entire useful life. Follow the text examples for formatting. Label each worksheet Building #1 DDB, Building #2 DDB, and Equipment DDB. In the same workbook, create Rosey's fixed asset depreciation worksheets using the sum-of-the-year'sdigits method and based on the same table. No summary sheet is required. Individual assets must show depreciation over their entire useful life. Follow the text examples for formatting. Label each worksheet Building #1 SYD, Building #2 SYD, and Equipment SYD. In the same workbook, you should now create a chart of each asset's depreciation that compares the straight-line, double declining balance, and sum-of-the-year's-digits methods of calculating depreciation. Label each worksheet Building #1 Chart, Building #2 Chart, and Equipment Chart. Choose any line chart and chart layout that you like. Save the workbook as ch4-06_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. 5) Chapter 5 Case Problem 4: ROSEY'S ROSES Rosey's Roses is considering several alternative means of financing an expansion. One alternative is to borrow $600,000 from a local bank, but another alternative is to borrow this amount from investors by issuing bonds. Both alternatives involve a 10-year debt period with annual payments. Modify the workbook ch508 to compute a loan and bond analysis, naming and formatting cell / / / / / ranges as appropriate. Assume an initial loan rate of 7 percent, an initial bond stated rate of 7 percent, and a market interest rate of 6.5 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. Use the Scenario Manager to create two loan scenarios called Best Case and Worst Case. In the Best Case, the rate would be 6 percent and the loan amount would be $550,000; in the Worst Case, the rate would be 8 percent and the loan amount would be $650,000. The resulting comparison values you're trying to predict are Payment, Total Payments, and Total Interest. Print the resulting summary worksheet. c. Use the Scenario Manager to create two bond scenarios called Best Case and Worst Case. In the Best Case, the market rate would be 6 percent and the stated rate would be 6.5 percent. In the Worst Case, the market rate would be 8.25 percent and the stated rate would be 8 percent. The resulting comparison values you're trying to predict are Proceeds, Total Interest Payments, and Total Interest Expense. Print the resulting summary worksheet. d. 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 monthly payment of $80,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. e. Use Excel's goal seek feature to calculate the market rate necessary to achieve bond proceeds of $650,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. 6) Chapter 6 Case Problem 4: ROSEY'S ROSES Rosey's Roses is contemplating several alternative means of financing their acquisition of $100,000 in new equipment in year 1. One option is to borrow $80,000 from a local bank. The bank has asked them to produce a 3-year cash budget broken down by year (Year 1, 2, and 3). Sales of $150,000 were earned in the prior year and are expected to increase each year thereafter by 15 percent. Purchases are based on an expected cost of sales of 60 percent and a required ending inventory of 20 percent of next year's sales. Prior year expenses included advertising expense of $15,000, depreciation expense of $1,000, wages expense of $20,000, supplies expense of $1,000, and utilities expense of $3,300. All expenses except depreciation and interest expense are paid in the year in which they are incurred and are expected to increase 10 percent each year. Interest expense is paid in the year incurred and is expected to remain constant at $4,000 each year for years 1-3. Collections in the year of sale are expected to be 85 percent, with the remaining 15 percent collected in the next year. Payments in the year of purchase are expected to be 90 percent, with the remaining 10 percent paid in the next year. Proceeds from the $80,000 loan are expected at the beginning of year 1, and $100,000 of equipment will be purchased during year 1. In subsequent years, equipment purchases are expected to be $2,000 each year. Proceeds from / / / projected equipment sales each year are expected to amount to $500. Annual payments of $10,360 on the loan occur at the end of each year. Using the ch6-07 file to start your work, create a cash budget (as you did in the chapter) based on the assumptions just provided. Use Excel's grouping feature to group operating cash receipts, operating cash payment, cash from (to) operating activities, cash from (to) investing activities, and cash from (to) financing activities. Define names as appropriate. Save your file as ch6-07_student_name (replacing student_name with your name). a. Print the newly completed worksheet in Value view, with your name and date printed in the lower left footer and the file name in the lower right footer. Print only columns A through E of the cash budget, no assumptions. b. Collapse rows to level 2, and then print the worksheet in Value view, with your name and date printed in the lower left footer and the filename in the lower right footer. Print only columns A through E of the cash budget, no assumptions. c. Collapse rows to level 2, and then use what-if analysis to calculate end-of-year cash if the sales growth each year were 0 percent. 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. Print only columns A through E of the cash budget, no assumptions. d. Undo the what-if analysis performed in part d. Collapse rows to level 2, and then use goal seek to determine what annual sales growth would be needed to produce an ending cash balance of $50,000 in year 3. 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. Print only columns A through E of the cash budget, no assumptions. Rosey's Roses Income Statement for the period ended Sales Less: Cost of Goods Sold Gross Margin Expenses: Advertising Communications Depreciation Payroll Rent Supplies Utilities Net income 12/31/2013 % of sales $ 175,000 100.0% 85,000 48.6% 90,000 51.4% $ 18,000 7,500 5,000 32,000 12,000 700 4,600 $ 79,800 10,200 10.3% $ 4.3% 2.9% 18.3% 6.9% 0.4% 2.6% 5.8% 12/31/2014 % of sales Amount % change $ 200,000 100.0% $ 25,000 105,000 52.5% 20,000 95,000 47.5% 5,000 17,000 6,500 5,000 36,000 13,000 800 4,000 $ 82,300 12,700 8.5% 3.3% 2.5% 18.0% 6.5% 0.4% 2.0% 6.4% $ $ $ $ $ $ $ $ (1,000) (1,000) 4,000 1,000 100 (600) 2,500 14% 24% 6% -6% -13% 0% 13% 8% 14% -1% 25% Rosey's Roses Balance Sheet as of 12/31/2013 Assets Current Assets: Cash Accounts Receivable Inventory Supplies Buildings Equipment Less: Accumulated Depreciation Total Liabilities and Stockholders' Equity Current Liabilities Accounts Payable Payroll Liabilities Long-Term Debt Owner's Equity Total 15,000.00 21,248.18 11,001.82 250.00 55,000.00 7,500.00 10,000.00 22,500.00 4,500.00 % of assets 12/31/2014 15.0% 21.2% 11.0% 0.3% 15,000.00 18,373.97 8,626.03 500.00 55.0% 7.5% 10.0% 75,000.00 7,500.00 15,000.00 27,000.00 22.5% 4.5% 25,000.00 5,000.00 70,000.00 3,000.00 100,000.00 47,500.00 52,500.00 100,000.00 % of assets Amount % change 13.6% 16.7% 7.8% 0.5% (2,874.21) (2,375.79) 250.00 0.0% -13.5% -21.6% 100.0% 68.2% 6.8% 13.6% 20,000.00 5,000.00 10,000.00 36.4% 0.0% 50.0% 10.0% 30,000.00 22.7% 4.5% 2,500.00 500.00 11.1% 11.1% 70.0% 64,300.00 58.5% (5,700.00) -8.1% 3.0% 15,700.00 110,000.00 14.3% 12,700.00 10,000.00 423.3% 10.0% 42,500.00 67,500.00 110,000.00 Rosey's Roses Ratio Analysis December 2014 Profitability Return on owners' investment Return on total investment Profit margin Gross margin Liquidity Current ratio Quick ratio Receivable turnover Inventory turnover Solvency Debt-to-equity Liability Assets Current Assets: Cash Accounts Receivable Inventory Supplies 81% 12% 6% 48% 1.42 1.13 10.88 12.17 6.01 0.86 33,873.97 Buildings Equipment Less: Accumulated Depreciation Total Liabilities and Stockholders' Equity Current Liabilities Accounts Payable Payroll Liabilities Long-Term Debt Owner's Equity Total 15,000.00 18,373.97 8,626.03 500.00 75,000.00 7,500.00 15,000.00 25,000.00 5,000.00 42,500.00 67,500.00 110,000.00 30,000.00 64,300.00 15,700.00 110,000.00 Advertising Communications Depreciation Payroll Rent Supplies Utilities $ 17,000 6,500 5,000 36,000 13,000 800 4,000 Advertising Communications Depreciation Payroll Rent Supplies Utilities Advertising Communications Depreciation Payroll Rent Supplies Utilities 31/12/2013 31/12/2014 $ 18,000 $ 17,000 7,500 6,500 5,000 ### 32,000 36,000 12,000 13,000 700 800 4,600 4,000 $40,000 $35,000 $30,000 $25,000 $20,000 $15,000 $10,000 $5,000 $- 31/12/2013 31/12/2014 Asset Date acquired Cost Salvage value Estimated useful life (years) Year Building #1 1/1/2013 $55,000 $4,000 15 Depreciation amount Accumulated depreciation 1 $3,400.00 $3,400.00 2 $3,400.00 $6,800.00 3 $3,400.00 $10,200.00 4 $3,400.00 $13,600.00 5 $3,400.00 $17,000.00 6 $3,400.00 $20,400.00 7 $3,400.00 $23,800.00 8 $3,400.00 $27,200.00 9 $3,400.00 $30,600.00 10 $3,400.00 $34,000.00 11 $3,400.00 $37,400.00 12 $3,400.00 $40,800.00 13 $3,400.00 $44,200.00 14 $3,400.00 $47,600.00 15 $3,400.00 $51,000.00 Asset Date acquired Cost Salvage value Estimated useful life Building #2 1/1/2014 $20,000 $1,000 5 year 1 2 3 4 5 Depreciation amount Accumulated depreciation $3,800.00 $3,800.00 $3,800.00 $7,600.00 $3,800.00 $11,400.00 $3,800.00 $15,200.00 $3,800.00 $19,000.00 Asset Date acquired Cost Salvage value Estimated useful life Equipment 1/1/2013 $7,500 $500 4 year 1 2 3 4 Depreciation amount Accumulated depreciation $1,750.00 $1,750.00 $1,750.00 $3,500.00 $1,750.00 $5,250.00 $1,750.00 $7,000.00 Asset Date acquired Cost Salvage value Estimated useful life (years) Year Building #1 1/1/2013 $55,000 $4,000 15 Depreciation amount Accumulated depreciation 1 $7,333.33 $7,333.33 2 $6,355.56 $13,688.89 3 $5,508.15 $19,197.04 4 $4,773.73 $23,970.77 5 $4,137.23 $28,108.00 6 $3,585.60 $31,693.60 7 $3,107.52 $34,801.12 8 $2,693.18 $37,494.30 9 $2,334.09 $39,828.39 10 $2,022.88 $41,851.28 11 $1,753.16 $43,604.44 12 $1,519.41 $45,123.85 13 $1,316.82 $46,440.67 14 $1,141.24 $47,581.91 15 $989.08 $48,570.99 Asset Date acquired Cost Salvage value Estimated useful life year Building #2 1/1/2014 $20,000 $1,000 5 Depreciation amount Accumulated depreciation 1 $8,000.00 $8,000.00 2 $4,800.00 $12,800.00 3 $2,880.00 $15,680.00 4 $1,728.00 $17,408.00 5 $1,036.80 $18,444.80 Asset Equipment Date acquired Cost Salvage value Estimated useful life year 1/1/2013 $7,500 $500 4 Depreciation amount Accumulated depreciation 1 $3,750.00 $3,750.00 2 $1,875.00 $5,625.00 3 $937.50 $6,562.50 4 $437.50 $7,000.00 Asset Date acquired Cost Salvage value Estimated useful life (years) Year Building #1 1/1/2013 $55,000 $4,000 15 Depreciation amount Accumulated depreciation 1 $6,375.00 $6,375.00 2 $5,950.00 $12,325.00 3 $5,525.00 $17,850.00 4 $5,100.00 $22,950.00 5 $4,675.00 $27,625.00 6 $4,250.00 $31,875.00 7 $3,825.00 $35,700.00 8 $3,400.00 $39,100.00 9 $2,975.00 $42,075.00 10 $2,550.00 $44,625.00 11 $2,125.00 $46,750.00 12 $1,700.00 $48,450.00 13 $1,275.00 $49,725.00 14 $850.00 $50,575.00 15 $425.00 $51,000.00 Asset Date acquired Cost Salvage value Estimated useful life year Building #2 1/1/2014 $20,000 $1,000 5 Depreciation amount Accumulated depreciation 1 $6,333.33 $6,333.33 2 $5,066.67 $11,400.00 3 $3,800.00 $15,200.00 4 $2,533.33 $17,733.33 5 $1,266.67 $19,000.00 Asset Date acquired Cost Salvage value Estimated useful life year Equipment 1/1/2013 $7,500 $500 4 Depreciation amount Accumulated depreciation 1 $2,800.00 $2,800.00 2 $2,100.00 $4,900.00 3 $1,400.00 $6,300.00 4 $700.00 $7,000.00 Asset Date acquired Cost Salvage value Estimated useful life (years) Building #1 1/1/2013 $55,000 $4,000 15 8000 Year SLN 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 $3,400.00 $3,400.00 $3,400.00 $3,400.00 $3,400.00 $3,400.00 $3,400.00 $3,400.00 $3,400.00 $3,400.00 $3,400.00 $3,400.00 $3,400.00 $3,400.00 $3,400.00 DDB $7,333.33 $6,355.56 $5,508.15 $4,773.73 $4,137.23 $3,585.60 $3,107.52 $2,693.18 $2,334.09 $2,022.88 $1,753.16 $1,519.41 $1,316.82 $1,141.24 $989.08 SYD $6,375.00 $5,950.00 $5,525.00 $5,100.00 $4,675.00 $4,250.00 $3,825.00 $3,400.00 $2,975.00 $2,550.00 $2,125.00 $1,700.00 $1,275.00 $850.00 $425.00 7000 6000 5000 Year SLN DDB SYD 4000 3000 2000 1000 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Asset Building #2 Date acqui 1/1/2014 Cost $20,000 Salvage val $1,000 Estimated u 5 year SLN 1 2 3 4 5 DDB $3,800.00 $3,800.00 $3,800.00 $3,800.00 $3,800.00 SYD $8,000.00 $4,800.00 $2,880.00 $1,728.00 $1,036.80 $6,333.33 $5,066.67 $3,800.00 $2,533.33 $1,266.67 9000 8000 7000 6000 5000 year SLN DDB SYD 4000 3000 2000 1000 0 1 2 3 4 5 Asset Date acquired Cost Salvage value Estimated useful life Equipment 1/1/2013 $7,500 $500 4 YEAR sln 1 2 3 4 $1,750.00 $1,750.00 $1,750.00 $1,750.00 ddb $3,750.00 $1,875.00 $937.50 $437.50 syd $2,800.00 $2,100.00 $1,400.00 $700.00 4000 3500 3000 YEA R sln ddb syd 2500 2000 1500 1000 500 0 1 2 3 4 5 Rosey's Roses Loan Amortization Schedule Loan Amount Rate Loan Term Payment $ 600,000.00 7.00% 10 $85,426.50 Pmt. # 1 2 3 4 5 6 7 8 9 10 Totals Payment Interest Principal $85,426.50 $ 42,000.00 $43,426.50 $85,426.50 $ 38,960.14 $46,466.36 $85,426.50 $ 35,707.50 $49,719.00 $85,426.50 $ 32,227.17 $53,199.33 $85,426.50 $ 28,503.22 $56,923.29 $85,426.50 $ 24,518.59 $60,907.92 $85,426.50 $ 20,255.03 $65,171.47 $85,426.50 $ 15,693.03 $69,733.47 $85,426.50 $ 10,811.69 $74,614.81 $85,426.50 $ 5,588.65 $79,837.85 $854,265.02 $254,265.02 $600,000.00 Balance $ 600,000.00 $ 556,573.50 $ 510,107.14 $ 460,388.14 $ 407,188.81 $ 350,265.52 $ 289,357.61 $ 224,186.14 $ 154,452.67 $ 79,837.85 $ $3,032,357.38 Rosey's Roses Bond Amortization Schedule Market Rate Stated Rate Face Value Bond Term Interest Payment Proceeds (Discount) / Premium 6.50% 7.00% $ 600,000.00 10 $ 42,000.00 $621,566.49 $21,566.49 Interest Payment Payment # 1 2 3 4 5 6 7 8 9 10 Totals $ $ $ $ $ $ $ $ $ $ $ 42,000.00 42,000.00 42,000.00 42,000.00 42,000.00 42,000.00 42,000.00 42,000.00 42,000.00 42,000.00 420,000.00 Interest Expense $ $ $ $ $ $ $ $ $ $ $ 40,401.82 40,297.94 40,291.19 40,290.75 40,290.72 40,290.72 40,290.72 40,290.72 40,290.72 1,291.37 364,026.66 Amortization $ $ $ $ $ $ $ $ $ $ $ 1,598.18 1,702.06 1,708.81 1,709.25 1,709.28 1,709.28 1,709.28 1,709.28 1,709.28 40,708.63 55,973.34 (Discount) Premium Carrying Value $21,566.49 $ 621,566.49 $ 19,968.31 $ 619,968.31 $ 19,864.43 $ 619,864.43 $ 19,857.68 $ 619,857.68 $ 19,857.24 $ 619,857.24 $ 19,857.21 $ 619,857.21 $ 19,857.21 $ 619,857.21 $ 19,857.21 $ 619,857.21 $ 19,857.21 $ 619,857.21 $ 19,857.21 $ 19,867.21 $ (19,142.14) $ 159,691.56 $ 4,978,843.70 Best case Rosey's Roses Loan Amortization Schedule Loan Amount Rate Loan Term Payment $ 550,000.00 6.00% 10 $74,727.38 Pmt. # 1 2 3 4 5 6 7 8 9 10 Totals Payment Interest Principal $74,727.38 $ 33,000.00 $41,727.38 $74,727.38 $ 30,496.36 $44,231.02 $74,727.38 $ 27,842.50 $46,884.88 $74,727.38 $ 25,029.40 $49,697.97 $74,727.38 $ 22,047.52 $52,679.85 $74,727.38 $ 18,886.73 $55,840.64 $74,727.38 $ 15,536.30 $59,191.08 $74,727.38 $ 11,984.83 $62,742.55 $74,727.38 $ 8,220.28 $66,507.10 $74,727.38 $ 4,229.85 $70,497.53 $747,273.77 $197,273.77 $550,000.00 Balance $ 550,000.00 $ 508,272.62 $ 464,041.60 $ 417,156.72 $ 367,458.75 $ 314,778.90 $ 258,938.25 $ 199,747.17 $ 137,004.63 $ 70,497.53 $ 0.00 $2,737,896.17 Best case Rosey's Roses Bond Amortization Schedule Market Rate Stated Rate Face Value Bond Term Interest Payment Proceeds (Discount) / Premium 6.00% 6.50% $ 600,000.00 10 $ 39,000.00 $622,080.26 $22,080.26 Interest Payment Payment # 1 2 3 4 5 6 7 8 9 10 Totals $ $ $ $ $ $ $ $ $ $ $ 39,000.00 $ 39,000.00 $ 39,000.00 $ 39,000.00 $ 39,000.00 $ 39,000.00 $ 39,000.00 $ 39,000.00 $ 39,000.00 $ 39,000.00 $ 390,000.00 $ Interest Expense Amortization 37,293.99 $ 37,191.63 $ 37,185.49 $ 37,185.12 $ 37,185.10 $ 37,185.10 $ 37,185.10 $ 37,185.10 $ 37,185.10 $ 1,185.70 $ 335,967.40 $ 1,706.01 1,808.37 1,814.51 1,814.88 1,814.90 1,814.90 1,814.90 1,814.90 1,814.90 37,814.30 54,032.60 (Discount) Premium Carrying Value $21,566.49 $ 621,566.49 $ 19,860.48 $ 619,860.48 $ 19,758.12 $ 619,758.12 $ 19,751.98 $ 619,751.98 $ 19,751.61 $ 619,751.61 $ 19,751.59 $ 619,751.59 $ 19,751.59 $ 619,751.59 $ 19,751.59 $ 619,751.59 $ 19,751.59 $ 619,751.59 $ 19,751.59 $ 19,761.59 $ (16,247.81) $ 161,632.30 $ 4,977,890.11 worst case Rosey's Roses Loan Amortization Schedule Loan Amount Rate Loan Term Payment $ 650,000.00 8.00% 10 $96,869.17 Pmt. # 1 2 3 4 5 6 7 8 9 10 Totals Payment Interest Principal $96,869.17 $ 52,000.00 $44,869.17 $96,869.17 $ 48,410.47 $48,458.70 $96,869.17 $ 44,533.77 $52,335.40 $96,869.17 $ 40,346.94 $56,522.23 $96,869.17 $ 35,825.16 $61,044.01 $96,869.17 $ 30,941.64 $65,927.53 $96,869.17 $ 25,667.44 $71,201.73 $96,869.17 $ 19,971.30 $76,897.87 $96,869.17 $ 13,819.47 $83,049.70 $96,869.17 $ 7,175.49 $89,693.67 $968,691.68 $318,691.68 $650,000.00 Balance $ 650,000.00 $ 605,130.83 $ 556,672.13 $ 504,336.73 $ 447,814.51 $ 386,770.50 $ 320,842.97 $ 249,641.24 $ 172,743.37 $ 89,693.67 $ 0.00 $3,333,645.96 Rosey's Roses Bond Amortization Schedule Market Rate Stated Rate Face Value Bond Term Interest Payment Proceeds (Discount) / Premium Interest Payment Payment # 1 2 3 4 5 6 7 8 9 10 Totals worst case 8.25% 8.00% $ 600,000.00 10 $ 48,000.00 $590,047.39 ($9,952.61) $ $ $ $ $ $ $ $ $ $ $ 48,000.00 48,000.00 48,000.00 48,000.00 48,000.00 48,000.00 48,000.00 48,000.00 48,000.00 48,000.00 480,000.00 Interest Expense $ $ $ $ $ $ $ $ $ $ $ 51,279.24 51,549.77 51,572.09 51,573.93 51,574.08 51,574.10 51,574.10 51,574.10 51,574.10 2,074.92 465,920.43 Amortization $ $ $ $ $ $ $ $ $ $ $ (3,279.24) (3,549.77) (3,572.09) (3,573.93) (3,574.08) (3,574.10) (3,574.10) (3,574.10) (3,574.10) 45,925.08 14,079.57 (Discount) Premium Carrying Value $21,566.49 $ 621,566.49 $ 24,845.73 $ 624,845.73 $ 25,116.26 $ 625,116.26 $ 25,138.58 $ 625,138.58 $ 25,140.42 $ 625,140.42 $ 25,140.57 $ 625,140.57 $ 25,140.59 $ 625,140.59 $ 25,140.59 $ 625,140.59 $ 25,140.59 $ 625,140.59 $ 25,140.59 $ 25,150.59 $ (24,358.59) $ 201,585.33 $ 5,025,953.92 Rosey's Roses Income Statement for the period ended Sales Less: Cost of Goods Sold Gross Margin Expenses: Advertising Communications Depreciation Payroll Rent Supplies Utilities Net income 12/31/2013 % of sales $ 175,000 100.0% 85,000 48.6% 90,000 51.4% $ 18,000 7,500 5,000 32,000 12,000 700 4,600 $ 79,800 10,200 10.3% $ 4.3% 2.9% 18.3% 6.9% 0.4% 2.6% 5.8% 12/31/2014 % of sales Amount % change $ 200,000 100.0% $ 25,000 105,000 52.5% 20,000 95,000 47.5% 5,000 17,000 6,500 5,000 36,000 13,000 800 4,000 $ 82,300 12,700 8.5% 3.3% 2.5% 18.0% 6.5% 0.4% 2.0% 6.4% $ $ $ $ $ $ $ $ (1,000) (1,000) 4,000 1,000 100 (600) 2,500 14% 24% 6% -6% -13% 0% 13% 8% 14% -1% 25% Rosey's Roses Balance Sheet as of 12/31/2013 Assets Current Assets: Cash Accounts Receivable Inventory Supplies Buildings Equipment Less: Accumulated Depreciation Total Liabilities and Stockholders' Equity Current Liabilities Accounts Payable Payroll Liabilities Long-Term Debt Owner's Equity Total 15,000.00 21,248.18 11,001.82 250.00 55,000.00 7,500.00 10,000.00 22,500.00 4,500.00 % of assets 12/31/2014 15.0% 21.2% 11.0% 0.3% 15,000.00 18,373.97 8,626.03 500.00 55.0% 7.5% 10.0% 75,000.00 7,500.00 15,000.00 27,000.00 22.5% 4.5% 25,000.00 5,000.00 70,000.00 3,000.00 100,000.00 47,500.00 52,500.00 100,000.00 % of assets Amount % change 13.6% 16.7% 7.8% 0.5% (2,874.21) (2,375.79) 250.00 0.0% -13.5% -21.6% 100.0% 68.2% 6.8% 13.6% 20,000.00 5,000.00 10,000.00 36.4% 0.0% 50.0% 10.0% 30,000.00 22.7% 4.5% 2,500.00 500.00 11.1% 11.1% 70.0% 64,300.00 58.5% (5,700.00) -8.1% 3.0% 15,700.00 110,000.00 14.3% 12,700.00 10,000.00 423.3% 10.0% 42,500.00 67,500.00 110,000.00 Rosey's Roses Ratio Analysis December 2014 Profitability Return on owners' investment Return on total investment Profit margin Gross margin Liquidity Current ratio Quick ratio Receivable turnover Inventory turnover Solvency Debt-to-equity Liability Assets Current Assets: Cash Accounts Receivable Inventory Supplies 81% 12% 6% 48% 1.42 1.13 10.88 12.17 6.01 0.86 33,873.97 Buildings Equipment Less: Accumulated Depreciation Total Liabilities and Stockholders' Equity Current Liabilities Accounts Payable Payroll Liabilities Long-Term Debt Owner's Equity Total 15,000.00 18,373.97 8,626.03 500.00 75,000.00 7,500.00 15,000.00 25,000.00 5,000.00 42,500.00 67,500.00 110,000.00 30,000.00 64,300.00 15,700.00 110,000.00 Advertising Communications Depreciation Payroll Rent Supplies Utilities $ 17,000 6,500 5,000 36,000 13,000 800 4,000 Advertising Communications Depreciation Payroll Rent Supplies Utilities Advertising Communications Depreciation Payroll Rent Supplies Utilities 31/12/2013 31/12/2014 $ 18,000 $ 17,000 7,500 6,500 5,000 ### 32,000 36,000 12,000 13,000 700 800 4,600 4,000 $40,000 $35,000 $30,000 $25,000 $20,000 $15,000 $10,000 $5,000 $- 31/12/2013 31/12/2014 Asset Date acquired Cost Salvage value Estimated useful life (years) Year Building #1 1/1/2013 $55,000 $4,000 15 Depreciation amount Accumulated depreciation 1 $3,400.00 $3,400.00 2 $3,400.00 $6,800.00 3 $3,400.00 $10,200.00 4 $3,400.00 $13,600.00 5 $3,400.00 $17,000.00 6 $3,400.00 $20,400.00 7 $3,400.00 $23,800.00 8 $3,400.00 $27,200.00 9 $3,400.00 $30,600.00 10 $3,400.00 $34,000.00 11 $3,400.00 $37,400.00 12 $3,400.00 $40,800.00 13 $3,400.00 $44,200.00 14 $3,400.00 $47,600.00 15 $3,400.00 $51,000.00 Asset Date acquired Cost Salvage value Estimated useful life Building #2 1/1/2014 $20,000 $1,000 5 year 1 2 3 4 5 Depreciation amount Accumulated depreciation $3,800.00 $3,800.00 $3,800.00 $7,600.00 $3,800.00 $11,400.00 $3,800.00 $15,200.00 $3,800.00 $19,000.00 Asset Date acquired Cost Salvage value Estimated useful life Equipment 1/1/2013 $7,500 $500 4 year 1 2 3 4 Depreciation amount Accumulated depreciation $1,750.00 $1,750.00 $1,750.00 $3,500.00 $1,750.00 $5,250.00 $1,750.00 $7,000.00 Asset Date acquired Cost Salvage value Estimated useful life (years) Year Building #1 1/1/2013 $55,000 $4,000 15 Depreciation amount Accumulated depreciation 1 $7,333.33 $7,333.33 2 $6,355.56 $13,688.89 3 $5,508.15 $19,197.04 4 $4,773.73 $23,970.77 5 $4,137.23 $28,108.00 6 $3,585.60 $31,693.60 7 $3,107.52 $34,801.12 8 $2,693.18 $37,494.30 9 $2,334.09 $39,828.39 10 $2,022.88 $41,851.28 11 $1,753.16 $43,604.44 12 $1,519.41 $45,123.85 13 $1,316.82 $46,440.67 14 $1,141.24 $47,581.91 15 $989.08 $48,570.99 Asset Date acquired Cost Salvage value Estimated useful life year Building #2 1/1/2014 $20,000 $1,000 5 Depreciation amount Accumulated depreciation 1 $8,000.00 $8,000.00 2 $4,800.00 $12,800.00 3 $2,880.00 $15,680.00 4 $1,728.00 $17,408.00 5 $1,036.80 $18,444.80 Asset Equipment Date acquired Cost Salvage value Estimated useful life year 1/1/2013 $7,500 $500 4 Depreciation amount Accumulated depreciation 1 $3,750.00 $3,750.00 2 $1,875.00 $5,625.00 3 $937.50 $6,562.50 4 $437.50 $7,000.00 Asset Date acquired Cost Salvage value Estimated useful life (years) Year Building #1 1/1/2013 $55,000 $4,000 15 Depreciation amount Accumulated depreciation 1 $6,375.00 $6,375.00 2 $5,950.00 $12,325.00 3 $5,525.00 $17,850.00 4 $5,100.00 $22,950.00 5 $4,675.00 $27,625.00 6 $4,250.00 $31,875.00 7 $3,825.00 $35,700.00 8 $3,400.00 $39,100.00 9 $2,975.00 $42,075.00 10 $2,550.00 $44,625.00 11 $2,125.00 $46,750.00 12 $1,700.00 $48,450.00 13 $1,275.00 $49,725.00 14 $850.00 $50,575.00 15 $425.00 $51,000.00 Asset Date acquired Cost Salvage value Estimated useful life year Building #2 1/1/2014 $20,000 $1,000 5 Depreciation amount Accumulated depreciation 1 $6,333.33 $6,333.33 2 $5,066.67 $11,400.00 3 $3,800.00 $15,200.00 4 $2,533.33 $17,733.33 5 $1,266.67 $19,000.00 Asset Date acquired Cost Salvage value Estimated useful life year Equipment 1/1/2013 $7,500 $500 4 Depreciation amount Accumulated depreciation 1 $2,800.00 $2,800.00 2 $2,100.00 $4,900.00 3 $1,400.00 $6,300.00 4 $700.00 $7,000.00 Asset Date acquired Cost Salvage value Estimated useful life (years) Building #1 1/1/2013 $55,000 $4,000 15 8000 Year SLN 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 $3,400.00 $3,400.00 $3,400.00 $3,400.00 $3,400.00 $3,400.00 $3,400.00 $3,400.00 $3,400.00 $3,400.00 $3,400.00 $3,400.00 $3,400.00 $3,400.00 $3,400.00 DDB $7,333.33 $6,355.56 $5,508.15 $4,773.73 $4,137.23 $3,585.60 $3,107.52 $2,693.18 $2,334.09 $2,022.88 $1,753.16 $1,519.41 $1,316.82 $1,141.24 $989.08 SYD $6,375.00 $5,950.00 $5,525.00 $5,100.00 $4,675.00 $4,250.00 $3,825.00 $3,400.00 $2,975.00 $2,550.00 $2,125.00 $1,700.00 $1,275.00 $850.00 $425.00 7000 6000 5000 Year SLN DDB SYD 4000 3000 2000 1000 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Asset Building #2 Date acqui 1/1/2014 Cost $20,000 Salvage val $1,000 Estimated u 5 year SLN 1 2 3 4 5 DDB $3,800.00 $3,800.00 $3,800.00 $3,800.00 $3,800.00 SYD $8,000.00 $4,800.00 $2,880.00 $1,728.00 $1,036.80 $6,333.33 $5,066.67 $3,800.00 $2,533.33 $1,266.67 9000 8000 7000 6000 5000 year SLN DDB SYD 4000 3000 2000 1000 0 1 2 3 4 5 Asset Date acquired Cost Salvage value Estimated useful life Equipment 1/1/2013 $7,500 $500 4 YEAR sln 1 2 3 4 $1,750.00 $1,750.00 $1,750.00 $1,750.00 ddb $3,750.00 $1,875.00 $937.50 $437.50 syd $2,800.00 $2,100.00 $1,400.00 $700.00 4000 3500 3000 YEA R sln ddb syd 2500 2000 1500 1000 500 0 1 2 3 4 5 Rosey's Roses Loan Amortization Schedule Loan Amount Rate Loan Term Payment $ 600,000.00 7.00% 10 $85,426.50 Pmt. # 1 2 3 4 5 6 7 8 9 10 Totals Payment Interest Principal $85,426.50 $ 42,000.00 $43,426.50 $85,426.50 $ 38,960.14 $46,466.36 $85,426.50 $ 35,707.50 $49,719.00 $85,426.50 $ 32,227.17 $53,199.33 $85,426.50 $ 28,503.22 $56,923.29 $85,426.50 $ 24,518.59 $60,907.92 $85,426.50 $ 20,255.03 $65,171.47 $85,426.50 $ 15,693.03 $69,733.47 $85,426.50 $ 10,811.69 $74,614.81 $85,426.50 $ 5,588.65 $79,837.85 $854,265.02 $254,265.02 $600,000.00 Balance $ 600,000.00 $ 556,573.50 $ 510,107.14 $ 460,388.14 $ 407,188.81 $ 350,265.52 $ 289,357.61 $ 224,186.14 $ 154,452.67 $ 79,837.85 $ $3,032,357.38 Rosey's Roses Bond Amortization Schedule Market Rate Stated Rate Face Value Bond Term Interest Payment Proceeds (Discount) / Premium 6.50% 7.00% $ 600,000.00 10 $ 42,000.00 $621,566.49 $21,566.49 Interest Payment Payment # 1 2 3 4 5 6 7 8 9 10 Totals $ $ $ $ $ $ $ $ $ $ $ 42,000.00 42,000.00 42,000.00 42,000.00 42,000.00 42,000.00 42,000.00 42,000.00 42,000.00 42,000.00 420,000.00 Interest Expense $ $ $ $ $ $ $ $ $ $ $ 40,401.82 40,297.94 40,291.19 40,290.75 40,290.72 40,290.72 40,290.72 40,290.72 40,290.72 1,291.37 364,026.66 Amortization $ $ $ $ $ $ $ $ $ $ $ 1,598.18 1,702.06 1,708.81 1,709.25 1,709.28 1,709.28 1,709.28 1,709.28 1,709.28 40,708.63 55,973.34 (Discount) Premium Carrying Value $21,566.49 $ 621,566.49 $ 19,968.31 $ 619,968.31 $ 19,864.43 $ 619,864.43 $ 19,857.68 $ 619,857.68 $ 19,857.24 $ 619,857.24 $ 19,857.21 $ 619,857.21 $ 19,857.21 $ 619,857.21 $ 19,857.21 $ 619,857.21 $ 19,857.21 $ 619,857.21 $ 19,857.21 $ 19,867.21 $ (19,142.14) $ 159,691.56 $ 4,978,843.70 Best case Rosey's Roses Loan Amortization Schedule Loan Amount Rate Loan Term Payment $ 550,000.00 6.00% 10 $74,727.38 Pmt. # 1 2 3 4 5 6 7 8 9 10 Totals Payment Interest Principal $74,727.38 $ 33,000.00 $41,727.38 $74,727.38 $ 30,496.36 $44,231.02 $74,727.38 $ 27,842.50 $46,884.88 $74,727.38 $ 25,029.40 $49,697.97 $74,727.38 $ 22,047.52 $52,679.85 $74,727.38 $ 18,886.73 $55,840.64 $74,727.38 $ 15,536.30 $59,191.08 $74,727.38 $ 11,984.83 $62,742.55 $74,727.38 $ 8,220.28 $66,507.10 $74,727.38 $ 4,229.85 $70,497.53 $747,273.77 $197,273.77 $550,000.00 Balance $ 550,000.00 $ 508,272.62 $ 464,041.60 $ 417,156.72 $ 367,458.75 $ 314,778.90 $ 258,938.25 $ 199,747.17 $ 137,004.63 $ 70,497.53 $ 0.00 $2,737,896.17 Best case Rosey's Roses Bond Amortization Schedule Market Rate Stated Rate Face Value Bond Term Interest Payment Proceeds (Discount) / Premium 6.00% 6.50% $ 600,000.00 10 $ 39,000.00 $622,080.26 $22,080.26 Interest Payment Payment # 1 2 3 4 5 6 7 8 9 10 Totals $ $ $ $ $ $ $ $ $ $ $ 39,000.00 $ 39,000.00 $ 39,000.00 $ 39,000.00 $ 39,000.00 $ 39,000.00 $ 39,000.00 $ 39,000.00 $ 39,000.00 $ 39,000.00 $ 390,000.00 $ Interest Expense Amortization 37,293.99 $ 37,191.63 $ 37,185.49 $ 37,185.12 $ 37,185.10 $ 37,185.10 $ 37,185.10 $ 37,185.10 $ 37,185.10 $ 1,185.70 $ 335,967.40 $ 1,706.01 1,808.37 1,814.51 1,814.88 1,814.90 1,814.90 1,814.90 1,814.90 1,814.90 37,814.30 54,032.60 (Discount) Premium Carrying Value $21,566.49 $ 621,566.49 $ 19,860.48 $ 619,860.48 $ 19,758.12 $ 619,758.12 $ 19,751.98 $ 619,751.98 $ 19,751.61 $ 619,751.61 $ 19,751.59 $ 619,751.59 $ 19,751.59 $ 619,751.59 $ 19,751.59 $ 619,751.59 $ 19,751.59 $ 619,751.59 $ 19,751.59 $ 19,761.59 $ (16,247.81) $ 161,632.30 $ 4,977,890.11 worst case Rosey's Roses Loan Amortization Schedule Loan Amount Rate Loan Term Payment $ 650,000.00 8.00% 10 $96,869.17 Pmt. # 1 2 3 4 5 6 7 8 9 10 Totals Payment Interest Principal $96,869.17 $ 52,000.00 $44,869.17 $96,869.17 $ 48,410.47 $48,458.70 $96,869.17 $ 44,533.77 $52,335.40 $96,869.17 $ 40,346.94 $56,522.23 $96,869.17 $ 35,825.16 $61,044.01 $96,869.17 $ 30,941.64 $65,927.53 $96,869.17 $ 25,667.44 $71,201.73 $96,869.17 $ 19,971.30 $76,897.87 $96,869.17 $ 13,819.47 $83,049.70 $96,869.17 $ 7,175.49 $89,693.67 $968,691.68 $318,691.68 $650,000.00 Balance $ 650,000.00 $ 605,130.83 $ 556,672.13 $ 504,336.73 $ 447,814.51 $ 386,770.50 $ 320,842.97 $ 249,641.24 $ 172,743.37 $ 89,693.67 $ 0.00 $3,333,645.96 Rosey's Roses Bond Amortization Schedule Market Rate Stated Rate Face Value Bond Term Interest Payment Proceeds (Discount) / Premium Interest Payment Payment # 1 2 3 4 5 6 7 8 9 10 Totals worst case 8.25% 8.00% $ 600,000.00 10 $ 48,000.00 $590,047.39 ($9,952.61) $ $ $ $ $ $ $ $ $ $ $ 48,000.00 48,000.00 48,000.00 48,000.00 48,000.00 48,000.00 48,000.00 48,000.00 48,000.00 48,000.00 480,000.00 Interest Expense $ $ $ $ $ $ $ $ $ $ $ 51,279.24 51,549.77 51,572.09 51,573.93 51,574.08 51,574.10 51,574.10 51,574.10 51,574.10 2,074.92 465,920.43 Amortization $ $ $ $ $ $ $ $ $ $ $ (3,279.24) (3,549.77) (3,572.09) (3,573.93) (3,574.08) (3,574.10) (3,574.10) (3,574.10) (3,574.10) 45,925.08 14,079.57 (Discount) Premium Carrying Value $21,566.49 $ 621,566.49 $ 24,845.73 $ 624,845.73 $ 25,116.26 $ 625,116.26 $ 25,138.58 $ 625,138.58 $ 25,140.42 $ 625,140.42 $ 25,140.57 $ 625,140.57 $ 25,140.59 $ 625,140.59 $ 25,140.59 $ 625,140.59 $ 25,140.59 $ 625,140.59 $ 25,140.59 $ 25,150.59 $ (24,358.59) $ 201,585.33 $ 5,025,953.92