Kim Mitchell, the new credit manager of the Vinson Corporation, was alarmed to find that Vinson...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Kim Mitchell, the new credit manager of the Vinson Corporation, was alarmed to find that Vinson sells on credit terms of net 90 days while industry-wide credit terms have recently been lowered to net 30 days. On annual credit sales of $2.38 million, Vinson currently averages 95 days of sales in accounts receivable. Mitchell estimates that tightening the credit terms to 30 days would reduce annual sales to $2,255,000, but accounts receivable would drop to 35 days of sales and the savings on investment in them should more than overcome any loss in profit. Assume that Vinson's variable cost ratio is 89%, taxes are 40%, and the interest rate on funds invested in receivables is 19%. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions above. Open spreadsheet Assuming a 365-day year, calculate the net income under the current policy and the new policy. Do not round intermediate calculations. Round your answers to the nearest dollar. Current policy: $ New policy: $ Should the change in credit terms be made? Tightening Credit Terms Firm's current credit terms, net Industry-wide credit terms, net Discounts Bad Debt Losses 90 days 30 days $0 $0 Firm's variable cost ratio 89.00% Tax rate 40.00% Interest rate on funds invested in receivables 19.00% Days in year 365 Current Credit Policy: Annual credit sales Days sales outstanding, DSO $2,380,000 95 days New Credit Policy, Tighten to Industry-Average Credit Terms: Annual credit sales Days sales outstanding, DSO Changing Credit Policy Analysis: Gross sales Discounts Net sales Variable costs Profit before credit costs and taxes Credit-related costs: Cost of carrying receivables Bad debt losses Profit before taxes Taxes Net income $2,255,000 35 days Clect or Projected Income Statement Under Current Credit Policy Credit Policy Change $2,380,000 -$125,000 0 0 Projeced Income Statement Under New Credit Policy $2,255,000 0 0 0 0 Taxes Net income Should the change in credit terms be made? Formulas Effect of Projected Income Credit Statement Under Policy Changing Credit Policy Analysis: Current Credit Policy Change Projeced Income Statement Under New Credit Policy Gross sales =B13 =F21-B21 =B17 Discounts =$B$5 =F22-B22 =$B$5 Net sales #N/A #N/A #N/A Variable costs #N/A #N/A #N/A Profit before credit costs and taxes #N/A #N/A #N/A Credit-related costs: Cost of carrying receivables Bad debt losses Profit before taxes Taxes Net income Should the change in credit terms be made? #N/A #N/A #N/A #N/A =$B$6 =F28-B28 =$B$6 #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A Kim Mitchell, the new credit manager of the Vinson Corporation, was alarmed to find that Vinson sells on credit terms of net 90 days while industry-wide credit terms have recently been lowered to net 30 days. On annual credit sales of $2.38 million, Vinson currently averages 95 days of sales in accounts receivable. Mitchell estimates that tightening the credit terms to 30 days would reduce annual sales to $2,255,000, but accounts receivable would drop to 35 days of sales and the savings on investment in them should more than overcome any loss in profit. Assume that Vinson's variable cost ratio is 89%, taxes are 40%, and the interest rate on funds invested in receivables is 19%. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions above. Open spreadsheet Assuming a 365-day year, calculate the net income under the current policy and the new policy. Do not round intermediate calculations. Round your answers to the nearest dollar. Current policy: $ New policy: $ Should the change in credit terms be made? Tightening Credit Terms Firm's current credit terms, net Industry-wide credit terms, net Discounts Bad Debt Losses 90 days 30 days $0 $0 Firm's variable cost ratio 89.00% Tax rate 40.00% Interest rate on funds invested in receivables 19.00% Days in year 365 Current Credit Policy: Annual credit sales Days sales outstanding, DSO $2,380,000 95 days New Credit Policy, Tighten to Industry-Average Credit Terms: Annual credit sales Days sales outstanding, DSO Changing Credit Policy Analysis: Gross sales Discounts Net sales Variable costs Profit before credit costs and taxes Credit-related costs: Cost of carrying receivables Bad debt losses Profit before taxes Taxes Net income $2,255,000 35 days Clect or Projected Income Statement Under Current Credit Policy Credit Policy Change $2,380,000 -$125,000 0 0 Projeced Income Statement Under New Credit Policy $2,255,000 0 0 0 0 Taxes Net income Should the change in credit terms be made? Formulas Effect of Projected Income Credit Statement Under Policy Changing Credit Policy Analysis: Current Credit Policy Change Projeced Income Statement Under New Credit Policy Gross sales =B13 =F21-B21 =B17 Discounts =$B$5 =F22-B22 =$B$5 Net sales #N/A #N/A #N/A Variable costs #N/A #N/A #N/A Profit before credit costs and taxes #N/A #N/A #N/A Credit-related costs: Cost of carrying receivables Bad debt losses Profit before taxes Taxes Net income Should the change in credit terms be made? #N/A #N/A #N/A #N/A =$B$6 =F28-B28 =$B$6 #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
Using the trial balance prepared for Binbutti Engineering in Part 4 of Problem 2-9A, prepare an income statement and statement of changes in equity for the three months ended July 31, 2014, and a...
-
The following data represent the responses to two questions asked in a survey of 40 college students majoring in business: What is your gender? (M = male; F = female) and What is your major? (A =...
-
Determine which of the following words or groups of words are terms and Which are nonterms. Extortion..............................Thomas Jefferson Laborious..............................Empire State...
-
The annual risk-free rate of return is 2 percent and the investor believes that the market will rise annually at 7 percent. If a stock has a beta coefficient of 1.5 and its current dividend is $1,...
-
Callaghan Companys annual factory depreciation is $450,000. Callaghan estimated it would operate the factory a total of 3,600 hours this year. The factory operated 300 hours in November and 200 hours...
-
Sweet Company is constructing a building. Construction began on February 1 and was completed on December 31. Expenditures were $1,080,000 on March 1, $720,000 on June 1, and $1,800,000 on December...
-
The following is the adjusted trial balance of Sierra Company. (Click on the Graded Worksheet Tab below.) Sierra Company Adjusted Trial Balance December 31 Account Title Debit Credit Cash $15,000...
-
How do these relevant legal principles apply: Duty of care Duty of obedience Duty of loyalty Shareholder Derivative suit Piercing the corporate veil...
-
what will you do as a hotel manager if a customer complained about bad service they received?
-
How do marketers use new products to maintain and grow their market share? Your response must include a specific example of a company that successfully grew its business or attracted a new target...
-
How do you encourage cross-functional synergy within your organization to break down silos and facilitate innovative solutions to complex challenges ?
-
1. what is intended internal resource strategies. How do you plan to develop or acquire resources (tangible and/or intangible) that would generate core competencies? What are examples of resource...
-
With this exercise, how do I do the null hypothesis testing. my H0 is infants will look at the two different people at the same amount of time (not really sure how to express this) my H_alternate is...
-
Under what conditions is the following SQL statement valid?
-
The efficient market hypothesis suggests that it is difficult to outperform the market on a consistent basis. Are there possible exceptions to the hypothesis that concern the valuation of common...
-
How might a Daily Spending Diary result in wiser consumer buying and more saving for the future?
-
Jamie Lee sat down with a salesperson to discuss a new vehicle and its $24,000 purchase price. Jamie Lee has heard that no one really pays the vehicle sticker price. What guidelines may be suggested...
Study smarter with the SolutionInn App