Use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. qtr1 = 1 if quarter 1, 0 otherwise; qtr2 = 1 if quarter 2, 0 otherwise; qtr3 = 1 if quarter 3, 0 otherwise. if required, round your answers to three decimal places. for subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (example: -300) if the constant is "1" it must be entered in the box. do not round intermediate calculation. value = + qtr1 + qtr2 + qtr3 (c) compute the quarterly forecasts for next year based on the model you developed in part (b). if required, round your answers to three decimal places. do not round intermediate calculation. quarter 1 forecast quarter 2 forecast quarter 3 forecast quarter 4 forecast

Pettijohn inc. the balance sheet and income statement shown below are for pettijohn inc. note that the firm has no amortization charges, it does not lease any assets, none of its debt must be retired during the next 5 years, and the notes payable will be rolled over. balance sheet (millions of $) assets 2016 cash and securities $ 1,554.0 accounts receivable 9,660.0 inventories 13,440.0 total current assets $24,654.0 net plant and equipment 17,346.0 total assets $42,000.0 liabilities and equity accounts payable $ 7,980.0 notes payable 5,880.0 accruals 4,620.0 total current liabilities $18,480.0 long-term bonds 10,920.0 total debt $29,400.0 common stock 3,360.0 retained earnings 9,240.0 total common equity $12,600.0 total liabilities and equity $42,000.0 income statement (millions of $) 2016 net sales $58,800.0 operating costs except depr'n $54,978.0 depreciation $ 1,029.0 earnings bef int and taxes (ebit) $ 2,793.0 less interest 1,050.0 earnings before taxes (ebt) $ 1,743.0 taxes $ 610.1 net income $ 1,133.0 other data: shares outstanding (millions) 175.00 common dividends $ 509.83 int rate on notes payable 1. what is the firm's current ratio? (points : 6) 0.97 1.08 1.20 1.33 2. what is the firm's quick ratio? (points : 6) 0.49 0.61 0.73 0.87 3. what is the firm's total assets turnover? (points : 6) 0.90 1.12 1.40 1.68 4. what is the firm's inventory turnover ratio? (points : 6) 4.38 4.59 4.82 5.06 5. what is the firm's debt ratio? (points : 6) 45.93% 51.03% 56.70% 70.00% 6. what is the firm's roa? (points : 6) 2.70% 2.97% 3.26% 3.59% 7. what is the firm's roe? (points : 6) 8.54% 8.99% 9.44% 9.91%

What are the forecasted levels of the line of credit and special dividends? (hints: create a column showing the ratios for the current year; then create a new column showing the ratios used in the forecast. also, create a preliminary forecast that doesn’t include any new line of credit or special dividends. identify the financing deficit or surplus in this preliminary forecast and then add a new column that shows the final forecast that includes any new line of credit or special dividend.) now assume that the growth in sales is only 3%. what are the forecasted levels of the line of credit and special dividends?

Suppose that jim plans to borrow money for an education at texas a& m university. jim will need to borrow $25,000 at the end of each year for the next five years (total=$125,000). jim wishes his parents could pay for his education but they can’t. at least, he qualifies for government loans with a reduced interest rate while he is in school. he has a special arrangement with aggiebank to lend him the money at a subsidized rate of 1% over five years without having to make a payment until the end of the fifth year. however, at the end of the fifth year, jim agrees to pay off the loan by borrowing from longhorn bank. longhorn bank will lend him the money he needs at an annual interest rate of 6%. jim agrees to pay back the longhorn bank with 20 annual payments and the payments will be uniform (equal annual payments including principal and interest). (i) calculate how much money jim has to borrow at the end of 5 years to pay off the loan with aggiebank. a. $121,336 b. $127,525 c. $125,000 d. $102,020 e. none of the above