Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Wildcat, Inc., has estimated sales (in millions) for the next four quarters as follows: Q1 Q2 Q3 Q4 Sales $ 120 $ 140 $ 160 $ 190 Sales for the first quarter of the year after this one are projected at $135 million. Accounts receivable at the beginning of the year were $53 million. Wildcat has a 45-day collection period. Wildcat’s purchases from suppliers in a quarter are equal to 40 percent of the next quarter’s forecast sales, and suppliers are normally paid in 36 days. Wages, taxes, and other expenses run about 25 percent of sales. Interest and dividends are $12 million per quarter. Wildcat plans a major capital outlay in the second quarter of $72 million. Finally, the company started the year with a cash balance of $69 million and wishes to maintain a $30 million minimum balance. a. Complete the following cash budget for Wildcat, Inc. (Enter your answers in millions. Negative amounts should be indicated by a minus sign. Do not round intermediate calculations and round your final answers to 2 decimal places, e.g., 32.16.) WILDCAT, INC. Cash Budget (in millions) Q1 Q2 Q3 Q4 Beginning cash balance $ 69.00 $ $ $ Net cash inflow Ending cash balance $ $ $ $ Minimum cash balance –30.00 –30.00 –30.00 –30.00 Cumulative surplus (deficit) $ $ $ $ Assume that Wildcat can borrow any needed funds on a short-term basis at a rate of 3 percent per quarter and can invest any excess funds in short-term marketable securities at a rate of 2 percent per quarter. b-1. Complete the following short-term financial plan for Wildcat, Inc. (Enter your answers in millions. Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Do not round intermediate calculations and round your final answers to 2 decimal places, e.g., 32.16.) WILDCAT, INC. Short-Term Financial Plan (in millions) Q1 Q2 Q3 Q4 Target cash balance $ 30.00 $ 30.00 $ 30.00 $ 30.00 Net cash inflow New short-term investments Income from short-term investments Short-term investments sold New short-term borrowing Interest on short-term borrowing Short-term borrowing repaid Ending cash balance $ $ $ $ Minimum cash balance Cumulative surplus (deficit) $ $ $ $ Beginning short-term investments $ $ $ $ Ending short-term investments $ $ $ $ Beginning short-term debt $ $ $ $ Ending short-term debt $ $ $ $ b-2. What is the net cash cost (total interest paid minus total investment income earned) for the year? (Enter your answers in millions. Do not round intermediate calculations and round your final answer to 2 decimal places, e.g., 32.16.) Net cash cost
Cooling Tools, Inc. is currently producing 1,069 of small refrigerators per month but the company’s CEO plans to increase production at a rate of 11.00 percent per month until the firm is producing 7,022 refrigerators per month. How many months will ..
Three years ago, Sam purchased a farm on contract from an older lady for $149,000 at 7% interest over 15 years. The lady died unexpectedly and the heirs would like Sam to pay off the contract now, which has a current remaining balance of $130,000 wit..
Metallica Bearings, Inc., is a young start-up company. No dividends will be paid on the stock over the next nine years because the firm needs to plow back its earnings to fuel growth. The company will pay a $12 per share dividend in 10 years and will..
If you buy a put option on a $100,000 dollar Treasury Bond futures contract with an exercise price of 95 and the price of the Treasury Bond is 120 at expiration, is the contract in the money, out of the money, or at the money? What is you profit or l..
Ten years ago you invested $1,000 for 10 shares of Providien, Inc. common stock. You sold the shares recently for $2,000. While you owned the stock it paid $10.08 per share in annual dividends. What was your rate of return on Providien stock?
You’re trying to determine whether to expand your business by building a new manufacturing plant. The plant has an installation cost of $11.9 million, which will be depreciated straight-line to zero over its four-year life. If the plant has projected..
Suppose the average return on an asset is 11.5 percent and the standard deviation is 20 percent. Further assume that the returns are normally distributed. Use the NORMDIST function in Excel to determine the probability that in any given year you will..
Five years ago you took out a 5/1 adjustable rate mortgage and the five-year fixed rate period has just expired, The loan was originally for $249,000 with 360 payments at 4.1% APR, compounded monthly. Now that you have made 60 payments, what is the r..
The Morris Corporation has $600,000 of debt outstanding, and it pays an interest rate of 8% annually. Morris’s annual sales are $3 million, its average tax rate is 40%, and its net profit margin on sales is 3%. If the company does not maintain a TIE ..
Discuss the mean absolute deviation (MAD) and the mean square error (MSE). Which do you think is a better indicator of the accuracy of a forecasting method and why?
A project is expected to generate an annual cash flow of $300,000 before debt service, during each of the first five years of operation. This expectation represents the mean of a probability distribution of possible cash flows, and has a standard dev..
The Sooner Equipment Company has total assets of $100 million. What impact will this action have on Sooner's debt ratio?
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd