Class 02 Financial Forecasting Assigment TEMPLATE

Class 02 Financial Forecasting Assigment TEMPLATE -...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
RIVENDELL INC. Sales growth rate 40% Average collection period 14.08 New PPE n/a Number of days' sales in inventory 107.6 Spreadsheet Assignment, Part 1 New long-term debt n/a Number of days' purchases in A/P 48.34 Greg Haws Cash dividends n/a Short-term interest rate 6.0% Required current ratio 2.0 Long-term interest rate 8.0% Required debt ratio 80% Dividend payout ratio 40.0% Stock repurchases $50 Fixed asset turnover 3.518 Depreciation life 30 Amortization life 20 Year Forecasted 2011 2012 Assumptions (i.e. assume increase at same rate of sales) BALANCE SHEET Assets Cash 31 Investment Securities 71 Receivables 83 Inventory 468 Total Current Assets 653 Long-Term Investments 256 607 Less: Accumulated Depreciation (28) 579 Other Long-Term Assets 41 Intangible Assets 100 Total Assets 1,629 Liabilities Accounts Payable 226 Unearned Revenue 36 Short-term Loans Payable 31 Total Current Liabilities 293 Long-term Debt 665 Other Long-Term Liabilities 258 Total Liabilities
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 01/13/2012 for the course MMBIO 361 taught by Professor Bernard during the Fall '11 term at BYU.

Ask a homework question - tutors are online