May you please show steps and formulas
Please answer these Questions showing steps and formulas Credit analyst John Adams is considering a $1,000 order from a new customer. The cost of lling the order is $950. John estimates collection costs are $20. The customer will pay in 60 days. If the appropriate cost of capital is 18%, what is the NPV of extending credit to the new customer? A credit analyst has received a $10,000 order from a new customer. The cost of lling the order (i.e., COGS) is $8,000 and collection costs are $200. The credit analyst notes that the COGS will be paid immediately. Further, it is assumed that the customer will repay the trade credit obligation in 60 days. It is also assumed that the collection costs will be incurred in 60 days. If the appropriate discount rate is 8%, what is the NPV of extending credit to the new customer? A credit analyst has receiveda $20,000 order from a new customer. The cost of lling the order (i.e., COGS) is $19,100 and collection costs are $500. The credit analyst notes that the COGS will be paid immediately. Further, it is assumed that the customer will repay the trade credit obligation in 90 days. It is also assumed that the collection costs will be incurred in 90 days. If the appropriate discount rate is 10%, what is the NPV of extending credit to the new customer? Use the following information for questions 4-8. Your rm's CFO has tasked you with evaluating the net present value associated with changing the rm's trade credit terms from net 30 days to net 45 dagsOther pertinent assumptions include: 0 Annual sales with existing credit terms = $5,000,000 0 Variable cost ratio with existing credit terms = 30% of revenues 0 Costs of collections with existing credit terms = 1% of revenues 0 Bad debt expense ratio with existing credit terms = 2% of revenues 0 Annual sales with new credit terms = $5,500,000 0 Variable cost ratio with new credit terms = 30% of revenues 0 Costs of collections with new credit terms = 1% of revenues 0 Bad debt expense ratio with new credit terms = 3% of revenues 0 Discount rate = 10% What is the daily net present value of the current trade credit policy? Assume that the variable costs are paid upfront while the costs of collections occur when the payment is received from the customer. What is the daily net present value of the new trade credit policy? Assume that the variable costs are paid upfront while the costs of collections occur when the payment is received from the customer. What is the aggregate increase in net present value from making this change to trade credit policy? What is the optimal cash discount percentage with the following nancial situation: Cash discount period=10 days, credit peri0d=30 days, and annual cost of capital=22%. Besley Inc., manufactures and sells wallboard for use in construction of modular homes. It sells on net 30 terms to contractors. Following are the last 6 months' sales and the AR balances at the end of June, the present (report) month. Calculate the uncollected balance percentages for this company. 8. Besley Inc., manufactures and sells wallboard for use in construction of modular homes. It sells on net 30 terms to contractors. Following are the last 6 months' sales and the A/R balances at the end of June, the present (report) month. Calculate the uncollected balance percentages for this company. Accounts Receivable Schedule; June 30 Month* Credit Sales Uncollected Amount January $ 75,000 $ 5,000 February 50,000 5,000 March 100,000 6,000 April 40,000 6,000 May 45,000 8.000 June 50,000 12,000 June 30 A/R balance $42,000 * assume all months have 30 daysThe following nancial data are to be used for questions 9-11: Cash & equivalents Accounts receivable Inventory Gross Fixed assets (Accumulated gem.) Total Assets Accounts payable Notes payable Operating accruals Current maturities Long-term debt Shareholders' equity Total Liabilities & Equity Revenues COGS Operating expenses Depreciation Interest Taxes Net Income Dividends 2000 $25 $450 $400 $1,000 {$200) $1,675 $100 $50 $60 $50 $400 $1,015 $1,675 m $1,500 $750 $700 $100 $40 $536} $5 541 $45 m $75 $700 $500 $1,000 {$250) $2,025 $200 $275 $55 $50 $382 $1,063 $2,025 m $2,250 $1,125 $750 $50 $45 & m $120 9. How long is the 2000 cash conversion period? 10. What is the 2001 cash conversion efficiency? 11. What is the 2001 sustainable growth rate? Use this formula g' NPM * (1- DPO )* (1+D/ E) A/S- [NPM * (1-DPO) * (1+ D/ E)] where NPM (net profit margin) = NI/Revenues DPO (dividend payout ratio) = Dividends/NI D/E (debt-to-equity ratio) = Total Liabilities/Equity A/R (assets-to-revenues ratio) = Total Assets/Revenues