Recalculate Dynamic Mattress’s financing plan (Spreadsheet 19.3) assuming that the firm wishes to maintain a minimum cash balance of $35...
Recalculate Dynamic Mattress’s financing plan (Spreadsheet 19.3) assuming that the firm wishes to maintain a minimum cash balance of $35 million instead of $30 million. Assume the firm can convince the bank to extend its line of credit to $100 million. (Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Do not round intermediate calculations. Enter your answers in millions rounded to 2 decimal places.)
Quarter
First Second Third Fourth
A. Cash requirements
Cash required for operations $ $ 30.00 $ −34.00 $ −75.00
Interest on bank loan
Interest on stretched payables
Total cash required $ $ $ $
B. Cash raised in quarter
Bank loan
Stretched payables
Securities sold
Total cash raised $ $ $ $
C. Repayments
Of stretched payables
Of bank loan
D. Addition to cash balances
E. Bank Loan
Beginning of quarter
End of quarter $ $ $ $
13 years ago
10
Answer(0)
Bids(0)
other Questions(10)
- _____ has recently been outlawed by several states
- HCA ( Unit _1 to Unit_4)
- BAM 513 ( Unit 1- Unit 4)
- How do you graph x>-1 and y is greater than or equal to -3
- Small-Business Idea Paper
- Impact
- CJS 230 Week 4 Assignment State and Federal Prison Systems Paper
- 1. Explain why the cost structure associated with many kinds of information goods and services might imply a market supplied by a small number of large firms.
- A single six-sided die is rolled. Find the probability of rolling a number less then 4
- Sales promotion Homework help