[EXCEL] Investment cash flows: Keswick Supply Company wants to set up a division that provides copy and fax services to businesses. Customers will be given 20 days to pay for such services. The annual revenue of the division is estimated to be $25,000. Assuming that the customers take the full 20 days to pay, what is the incremental cash flow associated with accounts receivable? Please use excel.

[EXCEL] Investment cash flows: Keswick Supply Company wants to set up a division that provides copy and fax services to businesses. Customers will be given 20 days to pay for such services. The annual revenue of the division is estimated to be $25,000. Assuming that the customers take the full 20 days to pay, what is the incremental cash flow associated with accounts receivable? Please use excel.

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter17: The Management Of Cash And Marketable Securities

Section: Chapter Questions

Problem 2P

See similar textbooks

Similar questions

[EXCEL] Payback: Nakamichi Bancorp has made an investment in banking software at a cost of $1,875,000. Management expects productivity gains and cost savings over the next several years. If, as a result of this investment, the firm is expected to generate additional cash flows of $586,212, $713,277, $431,199, and $318,697 over the next four years, what is the investment's payback period?
[EXCEL] Internal rate of return: Refer to Problem 4. What is the IRR that Franklin Mints management can expect on this project? please use excel. Problem 4: [EXCEL] Net present value: Management of Franklin Mints, a confectioner, is considering purchasing a new jelly bean-making machine at a cost of $312,500. They project that the cash flows from this investment will be $121,450 for the next seven years. If the appropriate discount rate is 14 percent, what is the NPV for the project?
Economics GO GREEN Recycling Company starts its recycling business today. It recycles paper, cardboard, aluminum, and glass. The initial investment for this business is $510,000. The net cash flow at the end of the first year of business is forecast to be only $10,000. But it is expected that the net cash flow will increase at a rate of $40,000 per year starting from the end of Year 2. (а) Draw a cash flow diagram for the first 5 years. (b) What is the present worth of ALL the cashflows for the first 5 years at an interest rate of 10% per year? Round off your final answer to the nearest integer. (c) If GO GREEN sells its business for $710,000 at the end of Year 5, can we say this business has achieved an internal rate of return greater than 20% per year? Why?
Your firm expects to receive a $20,000 payment from a supplier in 25 days. Calculate the increase in the cash inflow's present value if the cash inflow can be collected 5 days sooner. Assume an annual discount rate of 10%. A. -$56.18 b. $27.07 c. $19,9972.64 d. $18,587.25
Your company is planning to purchase a new log splitter for is lawn and garden business. The new splitter has an initial investment of $180,000. It is expected to generate $25,000 of annual cash flows, provide incremental cash revenues of $150,000, and incur incremental cash expenses of $100,000 annually. What is the payback period and accounting rate of return (ARR)?
Optimal Cash Transfer Barenbaum Industries projects that cash outlays of 4.5 million will occur uniformly throughout the year. Barenbaum plans to meet its cash requirements by periodically selling marketable securities from its portfolio. The firms marketable securities are invested to earn 12%, and the cost per transaction of converting securities to cash is 27. a. Use the Baumol model to determine the optimal transaction size for transfers from marketable securities to cash. b. What will be Barenbaums average cash balance? c. How many transfers per year will be required? d. What will be Barenbaums total annual cost of maintaining cash balances? What would the total cost be if the company maintained an average cash balance of 50,000 or of 0 (it deposits funds daily to meet cash requirements)?
A bookstore is planning to purchase an automated inventory/remote marketing system, which includes an upgrade to a more sophisticated cash register system. The package has an initial investment cost of $360,000. It is expected to generate $144,000 of annual cash flows, reduce costs and provide incremental cash revenues of $326,000, and incur incremental cash expenses of $200,000 annually. What is the payback period and accounting rate of return (ARR)?
Investment cash flows: Six Twelve Inc. is considering opening up a new convenience store in downtown New York City. The expected annual revenue is $800,000. To estimate the increase in working capital, analysts estimate the ratio of cash and cash equivalents to revenue to be 0.03 and the ratio of receivables, inventories, and payables to revenue to be 0.05, 0.10, and 0.04, respectively in the same industry. What is the incremental cash flows related to working capital when the store is opened?
Problem The Sandbox's Company has cash needs of P5 million per month. If Sandbox needs more cash, it can sell marketable securities, incurring a fee of P300 for each transaction. If Sandbox leaves its funds in marketable securities, it expects to earn approximately 0.50% per month on their investment. 1. Using the Baumol model, what level of cash infusion minimizes Sandbox’s costs associated with cash? Use a number, no decimal value no currency, no space, no commas. * 2. If Sandbox gets a cash infusion of P1 million each time it needs cash, what are the total costs per month associated its cash infusions? Use a number, no decimal value no currency, no space, no commas * please answer all questions. Thanks!
PROBLEM The Sandbox's Company has cash needs of P5 million per month. If Sandbox needs more cash, it can sell marketable securities, incurring a fee of P300 for each transaction. If Sandbox leaves its funds in marketable securities, it expects to earn approximately 0.50% per month on their investment. 4. If Sandbox gets a cash infusion of P1 million each time it needs cash, what are the total costs per month associated its cash infusions? Use a number, no decimal value no currency, no space, no commas * 5. If Sandbox gets a cash infusion of P1 million each time it needs cash, how many transactions would be associated with its cash investment? Use a number, no decimal value no currency, no space, no commas * 6. Using the Baumol model, what level of cash infusion minimizes Sandbox’s costs associated with cash? Use a number, no decimal value no currency, no space, no commas. * 7. If Sandbox gets a cash infusion of P1 million each time it needs cash, what are the transactions costs per…
Problem A: Baumol ModelABC Corporation would like to know what is its optimal cash balance for a disbursement account. The daily averagedisbursement is P40,000. Cost to transfer money into the account average P500 each time. If the money is not in this account,it could have been kept in a mutual fund account that would let ABC earn 3% per year. 1. Total cost of holding and maintaining the optimal cash balance
Comparing Cash Flow Streams: You’ve just joined the investment banking fi rm of Dewey, Cheatum, and Howe. They’ve offered you two different salary arrangements. You can have $95,000 per year for the next two years, or you can have $70,000 per year for the next two years, along with a $45,000 signing bonus today. The bonus is paid immediately, and the salary is paid at the end of each year. If the interest rate is 10 percent compounded monthly, which do you prefer?