Financial Forecasting Study Problems 14-4 (page 453) and 15-8 (page 482): rememb

Financial Forecasting Study Problems 14-4 (page 453) and 15-8 (page 482): remember to complete all parts of the problems and report the results of your analysis. Do not forget to show the necessary steps and explain how your attained that outcome using EXCEL.Problem: 14-4 Financial Forecasting-percent of Sales. Tulley Appliances Inc. projects next year s sales to be $20 million. Current sales are $15 million based on current assets of $5 million and fixed assets of $5 million. Firms net profit margin is 5 percent after taxes. Tulley forecasts that its current assets will rise in direct proportion to the increase in sales but that its fiexed assets will increase by only $100000. Currently Tulley has $1.5 million in accounts payable (which vary directly with sales) $2 million in long-term debt (due in 10 years) and common equity (including $4 million in retained earnings) totaling $6.4 million. Tulley plans to pay $500000 in common stock dividends next year. a. What are Tulley s total financing needs. Ie. total assets for the coming year? b. Given the firm s projections and dividend payment plans what are its discretionary financing needs? c. Based on your projections and assuming that the $100000 expansion in fixed assets will occur what is the largest increase in sales the firm can support without having to resort to the use of discretionary sources of financing?Problem 15-8; Cost of Accounts Receivable. Johnson Enterprises Inc. is involved in the manufacture of and sale of electronic components used in small AM/FM radios. The firm needs $300000 to finance an anticipated expansion in receivables due to increased sales. Johnson s credit terms are net 60 and its average monthly credit sales are $200000. IN general the firms customer pay within the credit period: Thus the firm s average accounts receivable balance is $400000. Chuck Idol Johnson s comptroller approached the firm s bank with a request for a loan for the $300000 using the firm s accounts receivable as collateral. The bank offered to make a loan at a rate of 2 percent over prime plus a 1 percent processing charge on all receivables pledged ($200000 per month). Furthermore the bank agreed to lend up to 75 percent of the face value of the receivables pledged. a. Estimate the cost of the receivables loan to Johnson when the firm borrows the $300000. The prime rate is currently 11 percent. b. Idol also requested a line of credit for $300000 from the bank. The bank agreed to grant the necessary line of credit at a rate of 3 percent over prime and required a 15 percent compensating balance. Johnson currently maintains an average demand deposit of $80000. Estimate the cost of the line of credit to Johnson. c. Which source of credit should Johnson select? Why? 1. InterestRate Risk and Ratio Analysis Complete 16-12 (page 513) and 16-16 (page 514) Remember to complete all parts of the problems and report the results of your analysis. Do not forget to show the necessary steps and explain how your attained that outcome in EXCEL format. ________________________________________Problem 16-9: Interest rate risk; Two years ago your corporate treasurer purchased for the firm a 20 year bond at its par value of $1000. The coupon rate on this security is 8 percent. Interest payments are made to bondholders once a year. Currently bonds of this particular risk class are yielding investors 9 percent. A cash shortage has forced you to instruct your treasurer ot liquidate the bond. a. At what price will your bond be sold? Assume annual compounding. b. What will be the amount of your gain or loss over the original purchase price? c. What would be the amount of your gain or loss had the treasurer originally purchased a bond with a 4-year rather than a 20 year maturity? (Assume all characteristics of the bonds are identical except their maturity periods.) d. What do we call this type of risk assumed by your corporate treasurer?Problem 16-13: Ratio Analysis Assuming a 360-day year calculate what the average investment in inventory would be for a firm given the following information in each case. a. The firm has sales of $600000 a gross profit margin of 10 percent and an inventory turnover ratio of 6. b. The firm has a cost-of-goods sold figure of $480000 and an average age of inventory of 40 days. c. The firm has a cost-of-goods-sold figure of $1.15 million and an inventory turnover rate of 5. d. The firm has a sales figure of $25 million a gross profit margin of 14 percent and an average age of inventory of 45 days.