Start with the partial model in the file attached. Marvel Pence, CEO of Marvel's Renovations, a...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Start with the partial model in the file attached. Marvel Pence, CEO of Marvel's Renovations, a custom building and repair company, is preparing documentation for a line of credit request from his commercial banker. Among the required documents is a detailed sales forecast for parts of 2020 and 2021: Sales Labor and Raw Materials May. 2020 $75.000 S80,000 June, 2020 $115.000 S75.000 July, 2020 $145.000 S105,000 August, 2020 $125,000 $85.000 September. 2020 $120.000 $65,000 October, 2020 $95,000 S70,000 November, 2020 $75,000 S30,000 December, 2020 $55,000 $35.000 Jашагy, 2021 $45.000 N/A Estimates obtained from the credit and collection department are as follows: collections within the month of sale, 20%; collections during the month following the sale, 60%, collections the second month following the sale. 25%. Payments for labor and raw materials are typically made during the month following the one in which these costs were incurred. Total costs for labor and raw materials are estimated for each month as shown in the table. General and administrative salaries will amount to approximately $25.000 a month lease payments under long-tem lease contracts will be $7.000 a month; depreciation charges will be $8,000 a month miscellaneous expenses will be $5,000 a mouthr income tax payments of $30,000 will be due in both August and December; and a progress payment of $95,000 on a new office suite must be paid in October. Cash on hand on July 1 will amount to $70.000, and a minimun cash balance of S30,000 will be maintained throughout the cash budget period. Input Data Collections during month of sale Collections during month after sale Collections during second month after sale Lease payments 20% 60% 25% - Note: When the percent collected during the second month after sale is changed, the percent for collections during month after sale is automatically changed so that 100% of sales are collected during the three- month period. Target cash balance General and administrative salaries S7,000 $30,000 $25,000 Depreciation charges Income tax payments (Sep & Dec) Miscellaneous expenses New office suite payment (Oct) Cash on hand July 1 $8,000 $30,000 $5,000 $95,000 $70,000 Sales, labor, and RM adjustment factor 0% Cash Surplus or Loan Requirement Minimurr Cash Balance $30,000 s30,000 $30,000 $30,000 $30,000 $30,000 Surplus Cash Requirement (Cum NCF $41,000 $4,000 $10,000 $71,000 $82,000 $104,000 Minimurn cash balance) If its customers began to pay late, this would slow down collections and thus increase the required oan amount. Also, if sales dropped off, this would have an effect on the required loan amount. Perform a sensitivity analysis that shows the effects of these two factors on the maximunn loan requirement. Start with the partial model in the file attached. Marvel Pence, CEO of Marvel's Renovations, a custom building and repair company, is preparing documentation for a line of credit request from his commercial banker. Among the required documents is a detailed sales forecast for parts of 2020 and 2021: Sales Labor and Raw Materials May. 2020 $75.000 S80,000 June, 2020 $115.000 S75.000 July, 2020 $145.000 S105,000 August, 2020 $125,000 $85.000 September. 2020 $120.000 $65,000 October, 2020 $95,000 S70,000 November, 2020 $75,000 S30,000 December, 2020 $55,000 $35.000 Jашагy, 2021 $45.000 N/A Estimates obtained from the credit and collection department are as follows: collections within the month of sale, 20%; collections during the month following the sale, 60%, collections the second month following the sale. 25%. Payments for labor and raw materials are typically made during the month following the one in which these costs were incurred. Total costs for labor and raw materials are estimated for each month as shown in the table. General and administrative salaries will amount to approximately $25.000 a month lease payments under long-tem lease contracts will be $7.000 a month; depreciation charges will be $8,000 a month miscellaneous expenses will be $5,000 a mouthr income tax payments of $30,000 will be due in both August and December; and a progress payment of $95,000 on a new office suite must be paid in October. Cash on hand on July 1 will amount to $70.000, and a minimun cash balance of S30,000 will be maintained throughout the cash budget period. Input Data Collections during month of sale Collections during month after sale Collections during second month after sale Lease payments 20% 60% 25% - Note: When the percent collected during the second month after sale is changed, the percent for collections during month after sale is automatically changed so that 100% of sales are collected during the three- month period. Target cash balance General and administrative salaries S7,000 $30,000 $25,000 Depreciation charges Income tax payments (Sep & Dec) Miscellaneous expenses New office suite payment (Oct) Cash on hand July 1 $8,000 $30,000 $5,000 $95,000 $70,000 Sales, labor, and RM adjustment factor 0% Cash Surplus or Loan Requirement Minimurr Cash Balance $30,000 s30,000 $30,000 $30,000 $30,000 $30,000 Surplus Cash Requirement (Cum NCF $41,000 $4,000 $10,000 $71,000 $82,000 $104,000 Minimurn cash balance) If its customers began to pay late, this would slow down collections and thus increase the required oan amount. Also, if sales dropped off, this would have an effect on the required loan amount. Perform a sensitivity analysis that shows the effects of these two factors on the maximunn loan requirement.
Expert Answer:
Answer rating: 100% (QA)
FORECASTED SALES May June July August September October November December January Sales 75000 115000 ... View the full answer
Related Book For
Intermediate Financial Management
ISBN: 978-1285850030
12th edition
Authors: Eugene F. Brigham, Phillip R. Daves
Posted Date:
Students also viewed these general management questions
-
Start with the partial model in the file Ch16 P18 Build a Model.xlsx on the textbook's Web site. Rusty Spears, CEO of Rusty's Renovations, a custom building and repair company, is preparing...
-
Start with the partial model in the file Ch16 P18 Build a Model.xlsx on the textbook?s Web site. Rusty Spears, CEO of Rusty?s Renovations, a custom building and repair company, is preparing...
-
Start with the partial model in the file Ch15 P12 Build a Model.xls on the textbook's Web site. Reacher Technology has consulted with investment bankers and determined the interest rate it would pay...
-
Q1 The spectrum of two light sources A and B are shown in Figure 1(a) and Figure 1(b) respectively: W Light Source A 10. wwwth [nm] 1.045,24 11.A Light Source B MA MA 1 ww.alanghem MA Figure 1(a)...
-
A: Suppose the production process for a firm is homothetic and has decreasing returns to scale. (a) On a graph with labor on the horizontal and capital k on the vertical axis, draw an isoquant...
-
The demand and supply functions for two interdependent goods are given by Q D 1 = 400 5P 1 3P 2 Q D 2 = 300 2P 1 3P 2 Q S 1 = 60 + 3P 1 Q S 2 = 100 + 2P 2 (a) Show that the equilibrium prices...
-
Question: National Medical Enterprises (NME) is a large for-profit hospital and health corporation. One of its hospitals, Los Altos Hospital, in Long Beach, California, paid one doctor $219,275,...
-
1. Prepare a context diagram for the new system. 2. Prepare a diagram 0 DFD for the new system. 3. Write a brief memo that explains at least five attributes that you can use to define a process in...
-
12b-1 Fees. What are 12b-1 fees? What expenses are 12b-1 fees intended to cover? Many closed-end mutual funds charge a 12b-1 fee. Does this make sense to you? Why or why not? Open-End versus...
-
Married taxpayers David and Lillian Perdue file jointly and have a daughter. Erin. They live at 9510 Bluebird Canyon Drive, Seattle, WA 99201. The Perdues own their home, which was paid off last...
-
What integrated marketing communication process involves coordinating all relevant marketing actions like packaging, sales promotions, distribution, and pricing? a) Horizontal integration b) Vertical...
-
Steph and Maya are standing atop a building looking down at a swimming pool. The pool is 10 m away from the building, and the building is 25 m tall. To jump off the pool, Maya tells Steph to run at 5...
-
Jake Sully works for the Pandora Mining Corporation (hereafter Pandora) as an executive. Pandoras stock is traded on an established securities market. On April 1, 2018, in connection with the...
-
Alibaba.com Transportation charges, who pays the buyer of the seller? how often do they ship? Are there any options? what is the method of Alibaba invoicing What type of credit is available from your...
-
1)What are the Advantages of JSP ? 2)What is jsp? 3) Types of Jsp Implicit Objects? 4) Types of JSP Tags/Elements? 5)JSP life cycle methods 6)Phases in JSP 7)MVC in JSP? Exception Handling in JSP?
-
The Pirates Cove Inn had total revenues of $750,000 for the month of June. Assume that the Pirates Cove Inns percentages for June were the same as the comparative results of operations information...
-
???Mark? Goldsmith's broker has shown him two bonds issued bydifferent companies. Each has a maturity of 5 ?years, a par valueof ?$1,000?, and a yield to maturity of 9.30%.??The fi 2 answers
-
Compile data on consumption and expenditures for the following categories in 30 different countries: (1) food and beverages, (2) clothing and footwear, (3) housing and home operations, (4) household...
-
Molteni Motors Inc. recently reported $6 million of net income. Its EBIT was $13 million, and its tax rate was 40%. What was its interest expense?
-
JPix management is considering a stock split. JPix currently sells for $120 per share and a 3-for-2 stock split is contemplated. What will be the company's stock price following the stock split,...
-
You are analyzing Jillian's Jewlery (JJ) stock for a possible purchase. JJ just paid a dividend of $1.50 yesterday. You expect the dividend to grow at the rate of 6% per year for the next 3 years; if...
-
Use the partition function \(Z\) for the quantum harmonic oscillator to find the average energy, \(\langle Eangle\).
-
Find the Taylor series centered at \(x=a\) and its corresponding radius of convergence for the given function. In most cases, you need not employ the direct method of computation of the Taylor...
-
Consider Gregory's expansion \[\tan ^{-1} x=x-\frac{x^{3}}{3}+\frac{x^{5}}{5}-\cdots=\sum_{k=0}^{\infty} \frac{(-1)^{k}}{2 k+1} x^{2 k+1}\] a. Derive Gregory's expansion using the definition \[\tan...
Study smarter with the SolutionInn App