Excel: Short-Term Finance

profilereded94
MGMT332_Excel_Template_8.xlsx
Home>Business & Finance homework help>Accounting homework help>Excel: Short-Term Finance

Prob. 1

1Q19 Income Statement (in M$) 1Q19 Balance Sheet (in M$)
Jan. Feb. Mar. Jan. Feb. Mar.
Sales Cash
Cost of goods sold Receivables
Gross margin Inventory
Sales, general & admin. Curr. Assets
Interest expense PP&E
Taxable income Total Assets
Taxes
Net income Payables
Notes Payable
Key Ratios Accruals
Jan. Feb. Mar. LTD
Days Receivable Curr. Liabilities
Days Inventory LTD
Operating Cycle Equity
Days Payable Total L&E
Cash Cycle

Prob. 2

a) Effective Annual Rate (EAR) b) Average Collection Period c) One-Time Client
Notional purchase Gross revenue Repair cost
Discount (%) Avg. receivables before new policy Default probability
Days difference
alfonso canella: alfonso canella: Difference in days from paying to get discount to paying with no discount		 % paying early NPV of client
Avg. receivables after new policy Break-even probability
Discount ($) Change in receivables Extend credit if probability of getting paid is higher than
Rate (%) Cost of capital
Days difference in 1 year Projected savings in capital costs
minus: discounts
EAR Projected savings net of discounts
Gross margin
Gross revenues must rise by:
- in dollars
- in percent