I need help with the following questions so I have attached the file

Suppose that Psy Ops Industries currently has the balance sheet shown below, and that sales for the year just ended were $4.4 million. The firm also has a profit margin of 20 percent, a retention ratio of 25 percent, and expects sales of $7.4 million next year. Assets Current assets Fixed assets $ 1,980,00 0 3,700,00 0 Total assets $ 5,680,00 0 Liabilitie s and Equity Current liabilities Longterm debt Equity Total liabilities and equity $ 1,672,00 0 1,800,00 0 2,208,00 0 $ 5,680,00 0 If fixed assets have enough capacity to cover the increase in sales and all other assets and current liabilities are expected to increase with sales, what amount of additional funds will Psy Ops need from external sources to fund the expected growth? (Enter your answer in dollars not in millions. Negative amount should be indicated by a minus sign.) Additional funds needed Suppose your firm is seeking a six-year, amortizing $880,000 loan with annual payments and your bank is offering you the choice between a $938,000 loan with a $58,000 compensating balance and a $880,000 loan without a compensating balance. The interest rate on the $880,000 loan is 9.0 percent. How low would the interest rate on the loan with the compensating balance have to be for you to choose it?(Do not round intermediate calculations and round your final answer to 2 decimal places.) Interest rate HotFoot Shoes would like to maintain its cash account at a minimum level of $34,000, but expects the standard deviation in net daily cash flows to be $4,900, the effective annual rate on marketable securities to be 7.4 percent per year, and the trading cost per sale or purchase of marketable securities to be $290 per transaction. What will be its optimal cash return point? (Use 365 days a year. Do not round intermediate calculations and round your answer to 2 decimal places.) Optimal cash return point Suppose a firm has had the following historic sales figures. Ye ar: $ Sal es 20 09 2,6 00, 00 0 $ 20 10 3,6 60, 00 0 $ 20 11 4,3 40, 00 0 $ 20 12 4,9 50, 00 0 $ 20 13 5,6 60, 00 0 What would be the forecast for next year's sales using regression to estimate a trend? Next year's sales Suppose a firm has had the following historic sales figures. Ye ar: $ Sal es 20 09 1,4 70, 00 0 $ 20 10 1,7 00, 00 0 $ 20 11 1,6 00, 00 0 $ 20 12 2,1 70, 00 0 $ 20 13 1,7 60, 00 0 What would be the forecast for next year's sales using regression to estimate a trend? Next year's sales Rose Axels faces a smooth annual demand for cash of $5.19 million, incurs transaction costs of $266 every time the company sells marketable securities, and can earn 3.4 percent on its marketable securities. What will be its optimal cash replenishment level? (Enter your answer in dollars not in millions. Round your answer to 2 decimal places.) Optimal cash HotFoot Shoes would like to maintain its cash account at a minimum level of $43,000 but expects the standard deviation in net daily cash flows to be $3,800, the effective annual rate on marketable securities to be 2.7 percent per year, and the trading cost per sale or purchase of marketable securities to be $380 per transaction. What will be its optimal upper cash limit? (Use 365 days a year. Do not round intermediate calculations and round your answer to 2 decimal places.) Optimal upper cash limit Suppose that LilyMac Photography has annual sales of $236,000, cost of goods sold of $171,000, average inventories of $5,100, average accounts receivable of $26,200, and an average accounts payable balance of $7,600. Assuming that all of LilyMac's sales are on credit, what will be the firm's cash cycle? (Use 365 days a year. Do not round intermediate calculations and round your final answer to 2 decimal places.) Cash cycle