Spreadsheet Modeling & Decision Analysis: A Practical Introduction to Business Analytics (MindTap Course List)
8th Edition
ISBN: 9781305947412
Author: Cliff Ragsdale
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 3, Problem 47QP
The CFO for Eagle Beach Wear and Gift Shop is in the process of planning for the company’s cash flows for the next 6 months. The following table summarizes the expected accounts receivables and planned payments for each of these months (in $100,000s).
The company currently has a beginning cash balance of $40,000 and desires to maintain a balance of at least $25,000 in cash at the end of each month. To accomplish this, the company has a number of ways of obtaining short-term funds:
- 1. Delay Payments. In any month, the company’s suppliers permit it to delay any or all payments for 1 month. However, for this consideration, the company forfeits a 2% discount that normally applies when payments are made on time. (Loss of this 2% discount is, in effect, a financing cost.)
- 2. Borrow Against Accounts Receivables. In any month, the company’s bank will loan it up to 75% of the accounts receivable balances due that month. These loans must be repaid in the following month and incur an interest charge of 1.5%
- 3. Short-Term Loan. At the beginning of January, the company’s bank will also give it a 6-month loan to be repaid in a lump sum at the end of June. Interest on this loan is 1% per month and is payable at the end of each month.
Assume the company earns 0.5% interest each month on cash held at the beginning of the month.
Create a spreadsheet model the company can use to determine the least costly cash management plan (i.e., minimal net financing costs) for this 6-month period. What is the optimal solution?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
McGwire Aerospace expects to have net cash flow of $12 million. The company forecasts that its operating costs excluding depreciation and amortization will equal 75 percent of the company’s sales. Depreciation and amortization expenses are expected to be $5 million and the company has no interest expense. All of McGwire’s sales will be collected in cash, costs other than depreciation and amortization will be paid in cash during the year, and the company’s tax rate is 40 percent. What is the company’s expected sales?
19
of
Vision Company purchased treasury stock with a cost of $16,000 during 2017. During the year,
the company paid dividends of $20,000 and issued bonds payable for proceeds of $860,000.
Cash flows from financing activities for 2017 total
Select one:
a. $840,000 net cash inflow
b. $856,000 net cash inflow
c. $860,000 net cash outflow
d. $824,000 net cash inflow
n September 2012, a 260,000 square foot Costco anchored shopping center was acquired in San Mateo, California for $36 million with a $26 million fully amortizing first mortgage loan from Union Bank. By 2018, the property had substantially appreciated in value and was worth $72 million and the owner wanted to access part or all of the increased equity value while paying little or no current taxes. The owner might:
Refinance the property with a larger loan
All these answers are correct
Sell the property under an installment sale contract
Trade the property for a property whose sale price is more than $54 million under Section 1031 of the Internal Revenue Code
Chapter 3 Solutions
Spreadsheet Modeling & Decision Analysis: A Practical Introduction to Business Analytics (MindTap Course List)
Ch. 3 - Prob. 1QPCh. 3 - Prob. 2QPCh. 3 - Prob. 3QPCh. 3 - Prob. 4QPCh. 3 - Prob. 5QPCh. 3 - Prob. 6QPCh. 3 - Refer to question 19 at the end of Chapter 2....Ch. 3 - Prob. 8QPCh. 3 - Prob. 9QPCh. 3 - Prob. 10QP
Ch. 3 - Prob. 11QPCh. 3 - Prob. 12QPCh. 3 - Prob. 13QPCh. 3 - Prob. 14QPCh. 3 - Prob. 15QPCh. 3 - Prob. 16QPCh. 3 - Prob. 17QPCh. 3 - Tuckered Outfitters plans to market a custom brand...Ch. 3 - Prob. 19QPCh. 3 - Prob. 20QPCh. 3 - Prob. 21QPCh. 3 - Prob. 22QPCh. 3 - Prob. 23QPCh. 3 - Prob. 24QPCh. 3 - Prob. 25QPCh. 3 - Prob. 26QPCh. 3 - A manufacturer of prefabricated homes has decided...Ch. 3 - Prob. 28QPCh. 3 - Prob. 29QPCh. 3 - Prob. 30QPCh. 3 - Prob. 31QPCh. 3 - Prob. 32QPCh. 3 - Prob. 33QPCh. 3 - Prob. 34QPCh. 3 - Prob. 35QPCh. 3 - Prob. 36QPCh. 3 - Prob. 37QPCh. 3 - Prob. 38QPCh. 3 - Prob. 39QPCh. 3 - Prob. 40QPCh. 3 - Prob. 41QPCh. 3 - Prob. 42QPCh. 3 - Prob. 43QPCh. 3 - Prob. 44QPCh. 3 - A natural gas trading company wants to develop an...Ch. 3 - Prob. 46QPCh. 3 - The CFO for Eagle Beach Wear and Gift Shop is in...Ch. 3 - Prob. 48QPCh. 3 - Prob. 1.1CCh. 3 - Prob. 1.2CCh. 3 - Prob. 1.3CCh. 3 - Prob. 1.4CCh. 3 - Prob. 2.1CCh. 3 - Prob. 2.2CCh. 3 - Prob. 2.3CCh. 3 - Prob. 2.4CCh. 3 - Prob. 2.5CCh. 3 - Kelly Jones is a financial analyst for Wolverine...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, management and related others by exploring similar questions and additional content below.Similar questions
- Mono Industries has a project with the following projected cash flows: Initial Cost, Year 0: P200,000 Cash flow year one: P25,000 Cash flow year two: P75,000 Cash flow year three: P150,000 Cash flow year four: P150,000 Using a 10% discount rate for this project and the NPV model, should this project be accepted or rejected?arrow_forwardMonica Britt has enjoyed sailing small boats since she was 7 years old, when her mother started sailing with her. Today, Monica is considering the possibility of starting a company to produce small sailboats for the recreational market. Unlike other mass-produced sailboats, however, these boats will be made specifically for children between the ages of 10 and 15. The boats will be of the highest quality and extremely stable, and the sail size will be reduced to prevent problems of capsizing. Her basic decision is whether to build a large manufacturing facility, a small manufacturing facility, or no facility at all. With a favourable market, Monica can expect to make R90,000 from the large facility or R60,000 from the smaller facility. If the market is unfavourable, however, Monica estimates that she would lose R30,000 with a large facility and she would lose only R20,000 with the small facility. Because of the expense involved in developing the initial moulds and acquiring the…arrow_forwardMonica Britt has enjoyed sailing small boats since she was 7 years old, when her mother started sailing with her. Today, Monica is considering the possibility of starting a company to produce small sailboats for the recreational market. Unlike other mass-produced sailboats, however, these boats will be made specifically for children between the ages of 10 and 15. The boats will be of the highest quality and extremely stable, and the sail size will be reduced to prevent problems of capsizing. Her basic decision is whether to build a large manufacturing facility, a small manufacturing facility, or no facility at all. With a favourable market, Monica can expect to make R90,000 from the large facility or R60,000 from the smaller facility. If the market is unfavourable, however, Monica estimates that she would lose R30,000 with a large facility and she would lose only R20,000 with the small facility. Because of the expense involved in developing the initial moulds and acquiring the…arrow_forward
- You are managing a software project with an initial budget estimate of 5 million USD. During interim cost and schedule performance analysis, you figured out that: You should have spent $650,000 till now based on your initial plans and 1,500 man/days of scheduled activities You spent $425,000 till now and completed 600 man/days of scheduled activities which should have cost $525,000 based on your initial plans. You re-estimated the budget required for the remaining work to be done as $4,500,000. Identify: BAC PV AC EV ETC Calculate: CPI SPI CV SV VAC EAC TCPI Once you've calculated this, what does it mean for your project and your stakeholders? Note: You won't be able to view anyone else's response until you've posted yours. Also, feel free to use Google, if needed to help give you further clarity on the formulas being used. Be sure to submit an initial, substantive post by Friday at 11:59 p.m. CST.arrow_forwardClinton Financial Consultants is a firm of chartered accountants and financial consultants. Amongst its many activities , it specializes in arranging finance for new entrepreneurs. It helps them in evaluation, preparing viable reports, documentation, legal documentation and finally obtaining a loan from banking or financial institutions. The task involves preparing a proposal, checking the background of the client firm for its creditworthiness, preparing pro forma balance sheets and profit and loss accounts for the term of the loan, carrying out a need analysis, preparing loan agreement documents and finally obtaining the loan for the client. To facilitate better management, the firm uses PERT. It is currently processing the proposed loan for Alfa enterprises. The team assigned for this project has identified the following activities: Activity Description Immediate Predecessor A Start preparing proposal as per template - B Check credit worthiness of firm - C Create a rough draft…arrow_forwardSachs Brands's defined benefit pension plan specifies annual retirement benefits equal to 1.5% × service years × final year's salary, payable at the end of each year. Angela Davenport was hired by Sachs at the beginning of 2007 and is expected to retire at the end of 2041 after 35 years' service. Her retirement is expected to span 18 years. Davenport's salary is $83,000 at the end of 2021 and the company's actuary projects her salary to be $245,000 at retirement. The actuary's discount rate is 9%. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) (Use appropriate factor(s) from the tables provided.) At the beginning of 2022, the pension formula was amended to: 1.60% × Service years × Final year's salary The amendment was made retroactive to apply the increased benefits to prior service years. Required: 1. What is the company's prior service cost at the beginning of 2022 with respect to Davenport after the amendment described above?2. Since the amendment occurred at…arrow_forward
- The following is a breakdown of supplying and installing a piece of equipment to a project owner, atthe time of contract: EGPCost of equipment 250,000Manpower (installation) 50,000Overhead and profits 70,000i – Calculate the price of supplying and installing the equipmentii – If the supply and installing of the equipment was delayed by the project owner, calculate theescalated price of works based on the FIDIC Red Book 1990 formula given:Updated cost of equipment 270,000 EGPBase price index of manpower 123.2Updated price index of manpower 144.9arrow_forwardRBL’s directors are looking to expand into a new suite of services. Although they are doing quite well in their existing lines of business, analysts have identified some new areas for development. One of these is expansion into manufacturing prefabricated homes. However, this venture requires a large amount of funding. To raise additional funds to finance this new project, the company is considering issuing a new bond.Required: Prepare a short report which supports the case for issuing a corporate bond. In your report:a.Explain what a corporate bond is,b.Outline the characteristics of the bond market,c. Explain the benefits of issuing bonds to raise financing.arrow_forwardConoly Co. has identified an investment projectwith the following cash flows. If the discount rate is 10 percent, what is the present valueof these cash flows? What is the present value at 18 percent? At 24 percent?Year Cash Flow1 $ 9602 8403 9354 1,350arrow_forward
- Good day. Can you please assist on the following question below Lorraine has received a lump sum of R500 000.00 from her retirement fund. She intends to use these funds to start a student accommodation business. In order to start this business, Lorraine would need approximately R1 million, funds are needed for building the students accommodationapartments and to register with various regulatory bodies. She has to source additional funding in order to realise this dream. In the business plan, Lorraine has outlined the following:• Accommodation will be offered ONLY to students in Cape Town, Johannesburg, Mpumalanga and Polokwane.• ONLY females will be approved to reside in these houses, between the age of 18 - 35.• Marketing of the business will be done on community Radio stations only at the four mentioned cities.• It is going to be a family business, Friends and relatives are in support of the idea but are not able to support the business financially. Q.1. Discuss ANY TWO labour…arrow_forwardGood day. Can you please assist on the following question below Lorraine has received a lump sum of R500 000.00 from her retirement fund. She intends to use these funds to start a student accommodation business. In order to start this business, Lorraine would need approximately R1 million, funds are needed for building the students accommodationapartments and to register with various regulatory bodies. She has to source additional funding in order to realise this dream. In the business plan, Lorraine has outlined the following:• Accommodation will be offered ONLY to students in Cape Town, Johannesburg, Mpumalanga and Polokwane.• ONLY females will be approved to reside in these houses, between the age of 18 - 35.• Marketing of the business will be done on community Radio stations only at the four mentioned cities.• It is going to be a family business, Friends and relatives are in support of the idea but are not able to support the business financially. Q.1. Discuss ANY TWO labour…arrow_forwardGood day. Can you please assist on the following question below Lorraine has received a lump sum of R500 000.00 from her retirement fund. She intends to use these funds to start a student accommodation business. In order to start this business, Lorraine would need approximately R1 million, funds are needed for building the students accommodationapartments and to register with various regulatory bodies. She has to source additional funding in order to realise this dream. In the business plan, Lorraine has outlined the following:• Accommodation will be offered ONLY to students in Cape Town, Johannesburg, Mpumalanga and Polokwane.• ONLY females will be approved to reside in these houses, between the age of 18 - 35.• Marketing of the business will be done on community Radio stations only at the four mentioned cities.• It is going to be a family business, Friends and relatives are in support of the idea but are not able to support the business financially. Q.4.1 Identify the TWO basis or…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Single Exponential Smoothing & Weighted Moving Average Time Series Forecasting; Author: Matt Macarty;https://www.youtube.com/watch?v=IjETktmL4Kg;License: Standard YouTube License, CC-BY
Introduction to Forecasting - with Examples; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=98K7AG32qv8;License: Standard Youtube License