Funds are available to pay company expenditures

Assignment Help Financial Management

Reference no: EM131986139

The financial manager at D. A. Branch & Sons must ensure that funds are available to pay company expenditures in the future but would also like to maximize investment income. Three short-term investment options are available over the next 6 months: A, a 1-month CD that pays 0.25%, available each month; B, a 3-month CD that pays 1.00%, available at the beginning of the first 4 months; and C, a 6-month CD that pays 2.3%, available in the first month. The net expenditures for the next 6 months are forecast as $50,000, ($12,000), $23,000, ($20,000), $41,000, and ($13,000). Amounts in parentheses indicate a net inflow of cash. The company must maintain a cash balance of at least $10,000 at the end of each month. The company currently has $200,000 in cash. Formulate as LP, setup and solve the problem in Excel. Please clearly specify your decision variables and define them properly.

Reference no: EM131986139

Questions Cloud

Calculate the mirr of project using reinvestment approach : Calculate the MIRR of the project using the discounting approach. Calculate the MIRR of the project using the reinvestment approach.

Type of exercise for prevention of osteoporosis : Now what is the best type of exercise for the prevention of osteoporosis?

Cash flow stream if the quoted interest rate : What is the value at the end of Year 3 of the following cash flow stream if the quoted interest rate is 10%,

Uses of technology across the health care industry : Analyze the types of technology trends you researched. Telemedicine and electronic health records

Funds are available to pay company expenditures : Branch & Sons must ensure that funds are available to pay company expenditures in the future but would also like to maximize investment income.

Plan of care for of child with duchenne muscular dystrophy : Which are the best foods for the RN to include in the plan of care for of a child with Duchenne muscular dystrophy?

Only domestic manufacturing operations : Locate the financial information for a company that has only domestic manufacturing operations.

Systems analysis-design-implementation-evaluation : Select one of the phases (systems analysis, design, implementation, evaluation, and maintenance) and evaluate its importance and impact on the entire life cycle

How the innovative business offerings positively affect : Project - Assessing how the innovative business offerings positively affect the customer perception of the Microsoft brand

User Account

All Pages