Question: Can you help fill in the empty cells below and show any formulas you use? One question with 3 parts listed below. I'm including another

Can you help fill in the empty cells below and show any formulas you use? One question with 3 parts listed below. I'm including another worksheet I already completed as part of this worksheet which you may need to help you answer these?

Can you help fill in the empty cells below andCan you help fill in the empty cells below and
4Q20 Income Statement (in MS) 4020 Balance Sheet (in MS) Oct. Nov. Dec. Oct. Nov. Dec. Sales 367 390 420 Cash 311 312 345 Cost of goods sold 210 211 215 Receivables 264 270 300 Gross margin 157 179 205 Inventory 44 47 49 Sales, general & admin. 44 48 50 Curr. Assets 619 629 694 Interest expense 13 12 12 PP &E 788 801 802 Taxable income 100 119 143 Total Assets 1,407 1,430 1,496 Taxes 20 22 29 Net income 80 97 114 Payables 144 133 134 Notes Payable Key Ratios Accruals 40 44 48 Oct. Nov. Dec. LTD 55 55 55 Days Receivable 22 21 22 Curr. Liabilities 239 232 237 Days Inventory 6 7 7 LTD 400 400 400 Operating Cycle 29 27 29 Equity 768 798 859 Days Payable 21 19 19 Total L&E 1,407 1,430 1,496 Cash Cycle 8 9 10A B C D E F G H a) Effective Annual Rate (EAR) I b) Average Collection Period c) One-Time Client Notional purchase Gross revenue Repair cost Discount (\"/0) Avg. receivables before new policy Default probability Days difference ' % paying early NPV of client Avg. receivables after new policy Break-even probability Discount ($) Change in receivables Extend credit if Rate (0/0) Cost of capital probability of getting Days difference in 1 year Projected savings in capital costs paid is higher than minus: discounts EAR Projected savings net of discounts Gross margin Gross revenues must rise by: - in dollars - in percent

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!