As an intern in the financial department of scandia kayaks, you assist jay chen, a financial analyst. jay has asked you to work with the company's current revenue and sales data in excel to develop scenarios and what-if analyses that identify ways to increase profits.
switch to the revenue and expenses worksheet. jay wants to know how profits would change if the company sold 5 percent fewer kayaks of each model. make a scenario to provide this information for jay as follows:
a. in the scenario manager, add a new scenario and use unit sales decrease 5% as the scenario name.
b. change the values in the range f12: h12. (hint: two scenarios are already defined for the revenue and expenses worksheet.)
c. use the information shown in table 1 below as the values for the changing cells.
table 1: unit sales decrease 5% scenario values
changing cell
value
dae_units_sold (f12)
20900
swede_units_sold (g12)
20283
finn_units_sold (h12)
19665
d. show the results of the unit sales decrease 5% scenario.

Maria am corporation uses the weighted-average method in its process costing system. the baking department is one of the processing departments in its strudel manufacturing facility. in june in the baking department, the cost of beginning work in process inventory was $4,880, the cost of ending work in process inventory was $1,150, and the cost added to production was $25,200. required: prepare a cost reconciliation report for the baking department for june.

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%

Calculate the required rate of return for climax inc., assuming that (1) investors expect a 4.0% rate of inflation in the future, (2) the real risk-free rate is 3.0%, (3) the market risk premium is 5.0%, (4) the firm has a beta of 2.30, and (5) its realized rate of return has averaged 15.0% over the last 5 years. do not round your intermediate calculations.