File Undo 5 ...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
File Undo 5 ✰ ܝܪ ܢܬ ܢܝ ܥ ܟ ܗ ܢ ܣ ܩ ܝ ܐ ܐ ܗ ܗ ܗ ܩ A 1 Tightening Credit Terms Excel Online Home Insert 6 Bad Debt Losses 14 Paste 15 X Cut Copy Format Painter Clipboard 16 10 Days in year 12 Current Credit Policy: 13 Annual credit sales Firm's current credit terms, net Industry-wide credit terms, net Discounts Firm's variable cost ratio Tax rate 9 Interest rate on funds invested in receivables 22 23 33 34 Data 17 Annual credit sales Arial Days sales outstanding, DSO 18 Days sales outstanding, DSO New Credit Policy, Tighten to Industry Average Credit Terms: 20 Changing Credit Policy Analysis: 21 Gross sales 29 Profit before taxes 30 Taxes 31 Net income 32 Discounts Net sales 24 Variable costs 25 Profit before credit costs and taxes 26 Credit-related costs: 27 Cost of carrying receivables 28 Bad debt losses Review View IURA- Should the change in credit terms be made? Font Tell me what you want to do 10 A Á A B 62.00% 40.00% 16.00% 365 $2,505,000 Projected Income Statement Under === 90 days 30 days SO $0 E $2,630,000 95 days C Current Credit Policy $2,630,000 0 35 days === D Alignment Effect of Credit Policy Change -$125,000 0 0 E Wrap Text Merge & Center - F General $ % 48 Projeced Income Statement Under New Credit Policy $2,505,000 0 template 0 Number G H Conditional Format Formatting as Table Tables I | J A 500 SI X H Insert Delete Format K Cells L Autosum Clear M AT O Sort & Find & Filter - Select Editing N 0 P Q R S x Excel Online File 5 Undo fox Home Insert X Cut [Copy ✔Format Painter Clipboard 7 Paste 20 21 Gross sales 22 Discounts 23 Net sales 24 Variable costs 25 A Changing Credit Policy Analysis: 26 27 28 Bad debt losses 29 Profit before taxes 30 Taxes 31 Net income Credit-related costs: Cost of carrying receivables Data Profit before credit costs and taxes Arial Formulas BIUD 32 33 Should the change in credit terms be made? 34 35 42 Credit-related costs: 43 Cost of carrying receivables 36 Changing Credit Policy Analysis: 37 Gross sales 38 Discounts Review 39 Net sales 40 Variable costs 41 Profit before credit costs and taxes 44 Bad debt losses 45 Profit before taxes 46 Taxes 47 Net income 48 49 Should the change in credit terms be made? 50 51 View Font 10 B -B13 -$8$5 -$B$6 Projected Income Statement Under Current Credit Policy $2,630,000 0 Projected Income Statement Under Current Credit Policy #N/A #N/A #N/A Tell me what you want to do #N/A A A A #N/A #N/A #N/A #N/A 0 === SEEED с D Effect of Credit Policy Change -$125,000 0 Change =F21-821 -F22-822 Effect of Credit Policy #N/A #N/A #N/A Alignment #N/A -F28-828 #N/A #N/A #N/A 0 2Wrap Text Merge & Center E F =817 =SBS5 Projeced Income Statement Under New Credit Policy -$B$6 General $2,505,000 #N/A #N/A #N/A Projeced Income Statement Under New Credit Policy #N/A $-% 98 48 #N/A #N/A #N/A 0 0 template Number G H H HAG Conditional Format Formatting as Table. I Tables J Gydy IX A Insert Delete Format K Cells L Σ AutoSum Clear M 20 Sort & Find & Filter Select - Editing N 0 P Q R S Excel Online Structured Activity: Tightening Credit Terms 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.63 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,505,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 62%, taxes are 40%, and the interest rate on funds invested in receivables is 16%. 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? + File Undo 5 ✰ ܝܪ ܢܬ ܢܝ ܥ ܟ ܗ ܢ ܣ ܩ ܝ ܐ ܐ ܗ ܗ ܗ ܩ A 1 Tightening Credit Terms Excel Online Home Insert 6 Bad Debt Losses 14 Paste 15 X Cut Copy Format Painter Clipboard 16 10 Days in year 12 Current Credit Policy: 13 Annual credit sales Firm's current credit terms, net Industry-wide credit terms, net Discounts Firm's variable cost ratio Tax rate 9 Interest rate on funds invested in receivables 22 23 33 34 Data 17 Annual credit sales Arial Days sales outstanding, DSO 18 Days sales outstanding, DSO New Credit Policy, Tighten to Industry Average Credit Terms: 20 Changing Credit Policy Analysis: 21 Gross sales 29 Profit before taxes 30 Taxes 31 Net income 32 Discounts Net sales 24 Variable costs 25 Profit before credit costs and taxes 26 Credit-related costs: 27 Cost of carrying receivables 28 Bad debt losses Review View IURA- Should the change in credit terms be made? Font Tell me what you want to do 10 A Á A B 62.00% 40.00% 16.00% 365 $2,505,000 Projected Income Statement Under === 90 days 30 days SO $0 E $2,630,000 95 days C Current Credit Policy $2,630,000 0 35 days === D Alignment Effect of Credit Policy Change -$125,000 0 0 E Wrap Text Merge & Center - F General $ % 48 Projeced Income Statement Under New Credit Policy $2,505,000 0 template 0 Number G H Conditional Format Formatting as Table Tables I | J A 500 SI X H Insert Delete Format K Cells L Autosum Clear M AT O Sort & Find & Filter - Select Editing N 0 P Q R S x Excel Online File 5 Undo fox Home Insert X Cut [Copy ✔Format Painter Clipboard 7 Paste 20 21 Gross sales 22 Discounts 23 Net sales 24 Variable costs 25 A Changing Credit Policy Analysis: 26 27 28 Bad debt losses 29 Profit before taxes 30 Taxes 31 Net income Credit-related costs: Cost of carrying receivables Data Profit before credit costs and taxes Arial Formulas BIUD 32 33 Should the change in credit terms be made? 34 35 42 Credit-related costs: 43 Cost of carrying receivables 36 Changing Credit Policy Analysis: 37 Gross sales 38 Discounts Review 39 Net sales 40 Variable costs 41 Profit before credit costs and taxes 44 Bad debt losses 45 Profit before taxes 46 Taxes 47 Net income 48 49 Should the change in credit terms be made? 50 51 View Font 10 B -B13 -$8$5 -$B$6 Projected Income Statement Under Current Credit Policy $2,630,000 0 Projected Income Statement Under Current Credit Policy #N/A #N/A #N/A Tell me what you want to do #N/A A A A #N/A #N/A #N/A #N/A 0 === SEEED с D Effect of Credit Policy Change -$125,000 0 Change =F21-821 -F22-822 Effect of Credit Policy #N/A #N/A #N/A Alignment #N/A -F28-828 #N/A #N/A #N/A 0 2Wrap Text Merge & Center E F =817 =SBS5 Projeced Income Statement Under New Credit Policy -$B$6 General $2,505,000 #N/A #N/A #N/A Projeced Income Statement Under New Credit Policy #N/A $-% 98 48 #N/A #N/A #N/A 0 0 template Number G H H HAG Conditional Format Formatting as Table. I Tables J Gydy IX A Insert Delete Format K Cells L Σ AutoSum Clear M 20 Sort & Find & Filter Select - Editing N 0 P Q R S Excel Online Structured Activity: Tightening Credit Terms 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.63 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,505,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 62%, taxes are 40%, and the interest rate on funds invested in receivables is 16%. 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? +
Expert Answer:
Answer rating: 100% (QA)
To address the question regarding whether the change in credit terms should be made we need to calculate the net income under the current credit polic... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these finance questions
-
Gross Profit Ratio Dexter Inc. recorded net sales of $50,000 during the period, and its cost of goods sold amounted to $30,000. Compute the companys gross profit ratio.
-
A firm offers terms of 2/10, net 30 a-What effective annual interest rate does the firm earn when a customer does not take the discount? (Use 365 days a year. Do not round intermediate calculations....
-
Home Town Supply does not segregate sales and sales taxes at the time of sale. The register total for March 16 is $10,388. All sales are subject to a 6% sales tax. Compute sales taxes payable and...
-
What are the energies of the two longest-wavelength lines in the Paschen series for hydrogen? What are the corresponding wavelengths? Give your answers to two significant figures.
-
Milton Green, CPA, is auditing the financial statements of Taylor Corporation for the year ended December 31, 2007. Green plans to complete the fieldwork and sign the auditor's report about March 10,...
-
Why are money market funds included in the broader measures of the money supply (M2 and M3) that the Federal Reserve introduced in 1980?
-
In Exercises 1518, use the given set of points to a. Compute b1. b. Compute the residual standard deviation se. c. Compute the sum of squares for x, (x x)2. d. Compute the standard error of b1, sb....
-
Kaizer Plastics produces a variety of plastic items for packaging and distribution. One item, container #145, has had a low contribution to profits. Last year, 20,000 units of container #145 were...
-
Sheffield Company manufactures power tools. The Electric Drill Division (an investment center) can purchase the motors for the drills from the Motor Division (another investment center) or from an...
-
Given this, answer the following questions: 1. Draw a diagram of the process using the format in Exhibit 7.3. 2. Consider a base case where a customer arrives every 40 seconds and the Customer...
-
It is December of 2020 and Frankie and Kensley Nguyen have come to you to discuss their 2020 tax situation and some changes they are proposing for the future. They are a married couple and have no...
-
A circular concrete pipe must be sized to carry water from a reservoir of constant elevation to a fruit processing plant that is 500 m away. The water level in the reservoir is 35 meters and gravity...
-
With a refined foundation of your PDMP in place, it's time to move forward with planning the implementation of your strategy. This phase is crucial as it involves turning your ideas and plans into...
-
Using synthetic division, what is the quotient for (4x +5x - 11x+26) (x+3)? If the remainder is non-zero, express the remainder term as a fraction using the divisor as the denominator.
-
1 Find the compound amount and compound interest if $2000 is invested for six years and interest is compounded continuously at the annual rate 7% The compound amount will be $ 3136.62 (Round to the...
-
The Cutting Department of Lasso Company has the following production and cost data for August. Production Costs 1. Started and completed 9,600 units. Beginning work in process $0 2. Started 2,300...
-
Consider the function y = f(x) graphed below. The two points marked on the graph are A = (1, 18) and B = (2, 108). Give a possible formula, of the form Ca, for the function graphed. y=
-
When an electric field is applied to a shallow bath of vegetable oil, why do tiny bits of thread floating in the oil align with the field like compasses in a magnetic field?
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Indicate, in each of the following situations, the number of exemptions the taxpayers are entitled to claim on their 2012 income tax returns. Number of Exemptions a. Donna, a 20-year-old single...
-
Walter, a single taxpayer, purchased a limited partnership interest in a tax shelter in 1985. He also acquired a rental house in 2012, which he actively manages. During 2012, Walter's share of the...
-
Sandblasting is a process in which an abrasive material, entrained in a jet, is directed onto the surface of a casting to clean its surface. In a particular setup for sandblasting, the casting of...
-
\(f(t)=\delta(t-\tau)\) corresponds to a force applied at a. \(t-\tau=0\) b. \(t-\tau <0\) c. \(t-\tau>0\)
-
Find the response of a viscously damped system under the periodic force whose values are given in Problem 1.116. Assume that \(M_{t}\) denotes the value of the force in newtons at time \(t_{i}\)...
Study smarter with the SolutionInn App