can you please help me solve this question. this is the third time I am posting the question .the question is asking for the net income statement. please stop providing me with wrong answers. you can use excel to solve for it
this is the full question. thank you
Net income under current policy :
Sales = $1,860,000.00
Less variable cost = $ 1,450,800.00
(sales*78%)
= $ 4,09,200.00
Add interest income
from receivables= $ 29,842.37 ( see working note 1)
= $439,042.37
Less tax @ 40% = $175,616.95
=$ 263,425.42 = ₹263,425 (rounded off)
* ans = $263,425
Net income under new policy :
Sales = $1,735,000.00
Less Variable cost = $ 1,353,300.00
= $ 381,700.00
Add interest income
From receivables= $ 3,418.55883
= $ 385,118.559
Less tax@ 40 % = $154,047.424
= $231,071.135
=$231, 071
* ans = $ 231,071.00
Working notes:
1. Interest income from receivables ( current policy)
Receivables = 95 days sale
= $1,860,000*95/365
= $484,109.589
Interest income from receivables ( current policy)
Receivables = 95 days sale
= $1,860,000*95/365
= $484,109.589
Interest on receivables = 25%
= $484,109.589 *25%*90/365
= $29,842.3719
Interest on receivables = 25%
= $484,109.589 *25%*90/365
= $29,842.3719
2. Interest income from receivables ( New policy)
Receivables = 35 days of sale
= $ 1,735,000 * 35/365
= $ 166,369.863
Interest on receivables = 25%
=$166,369.863 *25%*30/365
= $ 3,418.55883
can you please help me solve this question. this is the third time I am posting the question .the question is asking...
please This is the second time I am posting this question. I need help. thank you X Excel Online Structured Activity: Tightening Credit Terms Kim Mitchell, the new credit manager of the Vinsbn 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 A-Z sales of $1.86 million, Vinson currently averages 95 days of sales in accounts receivable. Mitchell estimates...
please help me to solve for this question Excel Online Structured Activity: Tightening Credit Terms omit 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 $1.86 million, Vinson currently averages 95 days of sales in accounts receivable. Mitchell estimates that tightening the credit terms to 30 days would...
I need help with this question. it is an Accounting question . Attempts: 0 Keep the Highest: 0/3 1. Problem 22-05 (Relaxing Collection Efforts) eBook 1 Problem Walk-Through Relaxing Collection Efforts The Boyd Corporation has annual credit sales of $2.72 million. Current expenses for the collection department are $45,000, bad-debt losses are 2%, and the days sales outstanding is 30 days. The firm is considering easing its collection efforts such that collection expenses will be reduced to $27,000 per year....
Show the Excel Formulas Please. Accounts receivable analysis The following data are taken from the financial statements of Sigmon Inc. Terms of all sales are 2/10, n/45. 2043 2042 2041 Accounts receivable, end of year $580,000 $705,000 5,696,000 $655,000 4,520,500 Sales on account This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet a. For 20Y2 and 2043, determine (1) the accounts...
Tightening Credit Terms Firm's current credit terms, net Industry-wide credit terms, net Discounts Bad Debt Losses Firm's variable cost ratio Tax rate Interest rate on funds invested in receivables Days in year 90 days 30days 63.00% 40.00% 20.00% Current Credit Policy Annual credit sales Days sales outstanding. DSO 2,840,000 95 days New Credit Policy, Tighten to Industry-Average Credit Terms Annual credit sales Days sales outstanding, DSO $2,715,000 35days Effect of Projected Income Statement Under Current Credit Policy Statement Under New...
McEwan Industries sells on terms of 3/10, net 25. Total sales for the year are $601,000; 40% of the customers pay on the 10th day and take discounts, while the other 60% pay, on average, 54 days after their purchases. Assume 365 days in year for your calculations. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. What is the days sales outstanding? Round...
Hello, I am requesting help with the following question. Can you please show the work on how to derive at the correct answer? Thank you Proposal #1 would extend trade credit to some customers that previously have been denied credit because they were considered poor risks. Sales are projected to increase by $200,000 per year if credit is extended to these new customers. Of the new accounts receivable generated, 6% are projected to be uncollectible. Additional collection costs are projected...
Starset, Inc., has an average collection period of 50 days. Its average daily investment in receivables is $44,300. Assume 365 days per year. a. What is the receivables turnover? (Do not round intermediate calculations and round your answer to 4 decimal places, e.g., 32.1616.) b. What are annual credit sales? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) The Snedecker Corporation is considering a change in its cash-only policy. The new terms would...
please this question is giving me problem. please help me to solve for it .please Excel Online Structured Activity: Lease versus Buy Sadik Industries must install $1 million of new machinery in its Texas plant. It can obtain a bank loan for 100% of the required amount. Alternatively, a Texas investment banking firm that represents a group of investors believes that it can arrange for a lease financing plan. Assume that these facts apply: 1. The equipment falls in the...
I need this done asap. Please help me solve this. Thanks. Due in 1 hour. Partial-year depreciation Equipment acquired at a cost of $60,000 has an estimated residual value of $4,000 and an estimated useful life of 10 years. It was placed in service on May 1 of the current fiscal year, which ends on December 31. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in...