The following table includes quarterly working capital levels for your firm for the next year. (Click on the following icon to export the data displayed below.) Quarters ($000) Cash Accounts Receivable Inventory Accounts Payable 1 96 207 208 109 2 96 106 499 93 3 96 93 905 107 4 96 594 49 97 If you chose to use only long-term financing, what total amount of borrowing would you need to have on a permanent basis? Forecast your excess cash levels under this scenario. The amount you would need to borrow using only long-term capital on a permanent basis is $. (Round to the nearest dollar.) h Calculate the excess cash for each quarter below: (Round to the nearest integer.)

The following table includes quarterly working capital levels for your firm for the next year. (Click on the following icon to export the data displayed below.) Quarters ($000) Cash Accounts Receivable Inventory Accounts Payable 1 96 207 208 109 2 96 106 499 93 3 96 93 905 107 4 96 594 49 97 If you chose to use only long-term financing, what total amount of borrowing would you need to have on a permanent basis? Forecast your excess cash levels under this scenario. The amount you would need to borrow using only long-term capital on a permanent basis is $. (Round to the nearest dollar.) h Calculate the excess cash for each quarter below: (Round to the nearest integer.)

Fundamentals Of Financial Management, Concise Edition (mindtap Course List)

10th Edition

ISBN:9781337902571

Author:Eugene F. Brigham, Joel F. Houston

Publisher:Eugene F. Brigham, Joel F. Houston

Chapter16: Financial Planning And Forecasting

Section: Chapter Questions

Problem 2P: AFN EQUATION Refer to Problem 16-1. What additional funds would be needed if the companys year-end...

See similar textbooks

Similar questions

The following table includes quarterly working capital levels for your firm for the next year. (Click on the following icon in order to copy the contents into a spreadsheet.) ($000) Cash 1 110 208 205 96 2 Quarters 110 105 499 104 3 110 109 904 109 4 110 604 47 99 Accounts Receivable Inventory Accounts Payable If you want to limit your maximum short-term borrowing to $506,000 and maintain a minimum cash balance of $110,000, how much excess cash must you carry? The excess cash needed is $ (Round to the nearest dollar.)
An investor is told that the following cash flow profile has a present value of $11,000 assuming that the money received at each time period is placed into an account where it earns 18% annually. For what value of X will this be true? Year Cash Flow Click here to access the TVM Factor Table calculator. $ 1 2 3 4 5 6 7 $1,300 $1,600 X X $3,000 $1,600 $400 Carry all interim calculations to 5 decimal places and then round your final answer to a whole number. The tolerance is ±5.
Calculate the EAR of the following investment, entered as a percentage (Example: if your answer is 0.145, enter 14.5) Year Number Cashflow 0 -11400 1 3500 2 3000 3 3100 4 2800 Your Answer:
A company would like to have $400,000 in 6 years. How much should be invested semiannually into an account paying 3.6% compounded semiannually? 7. Identify the type of problem. a. Present Value with compound interest b. Future Value of an Annuity c. Present Value of an Annuity d. Amortization e. Sinking Fund 8. Answer the question in the problem. a. $30,681.38 b. $29,754.02. c. $34,245.54 d. $30,160.79 c. $28,541.46
Suppose that you have generated the estimates listed below from a pro forma analysis for a company that had requested a three year loan. The loan is a $1.5 million term loan with the equal annual payments of principals. The P&I payments are due at the end of each year with the annual interest rate = Prime rate + 1.5%. Yr.1 Yr. 2 Yr. 3 Capital expenditure 250,000 125,000 75,000 Cash dividends 140,000 140,000 140,000 Cash flow from operations before interest expense 750,000 780,000 800,000 Assuming the Prime rate = 7.5% each year. What will be the interest payment at year 3? a). 25,000 b). 50,000 c). 45,000 d). 53,000 e). 10,000
Calculate the APR of the following investment, entered as a percentage (Example: if your answer is 14.5%, enter 14.5 and not 0.145) Year Number Cashflow 0 -11000 1 3000 2 3500 3 2900 4 2800
Damien offers you a sequence of end-of-year cash flows for an investment as follows: Year 1 2 3 4 4 What is the value of the cash flows if the opportunity cost is 6 percent? (Round to the nearest dollar). Please click on the following link to access a blank worksheet Click to open:: O $8.392 $8.598 Cash Flow $4,000 $3,000 $2,000 $1,000 $8.734 $8.915
AFN EQUATION Refer to Problem 16-1. What additional funds would be needed if the companys year-end 2019 assets had been 4 million? Assume that all other numbers are the same. Why is this AFN different from the one you found in Problem 16-1? Is the companys capital intensity the same or different? Explain.
ABC Enterprise would like to evaluate/analyze a potential investment.. Given the following:Investment amount - 450,000 (2022)Dividends / Revenue stream - 100,000 for the first year and an interval of 5,000 for the succeeding years Discount rate - 14%a. NPV for the perio 2023 through 2029;b. Total NPV using manual computation;c. Total NPV using the Excel function; andd. IRR rate.
You have been depositing money into an account yearly based on the following investment amounts, rates and times, what is the value of that investment account at the end of that period? (Click here to see present value and future value tables) Amounts ofInvestment Rate Times Value at the Endof the Period $9,000 20% 16 years $fill in the blank 1 $13,000 15% 11 years $fill in the blank 2 $16,000 12% 6 years $fill in the blank 3 $35,000 10% 4 years $fill in the blank 4
Kabab Co. is considering a $240,000 investment, which will provide net returns of $110,000, $160,000, and $220,000 in the second, third, and fourth years, respectively. What is the payback period? Round up to the next month Use the following table: Cumulative Cash Cash Outflow Çash Inflow Net Cash Year Flow Flow 2 years and 10 months Ob. 2 years and 9 months 2 years and 11 months Od. 2 years and 8 months
REQUIRED Calculate the following from the information given below: 4.1.1 Payback Period (expressed in years, months and days). 4.1.2 Accounting Rate of Return on initial investment (expressed to two decimal places). 4.1.3 Internal Rate of Return (expressed to two decimal places) if the net cash inflows are R400 000 per year for five years. Your answer must include two net present value calculations (using consecutive rates/percentages) and interpolation. INFORMATION VRH Ltd is considering the purchase of Machine X, details of which are provided below: Initial investment Net cash inflows: Year R 0 (1 500 000) 1 480 000 2 600 000 3 380 000 4 272 000 5 360 000 The cost of capital is 12%. Depreciation is calculated using the straight-line method. No scrap value is expected for the machine. Ignore taxes.