Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out
Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

Answers - Video Financial Modelling

VIEWS: 4 PAGES: 784

									CFADS and DSCR - Words from a Foreign Language


               Like this? Check out our


Example - CFADS

   Question: Find the Cash Flow Available for Debt Service based on the following inputs.
   Revenue                                                       50
   Expenses                                                    (10)
   Capital Expenditure                                         (15)
   Tax                                                           (5)
   Working Capital Movements                                     (2)
   Depreciation                                                (10)

   Answer:


Example - DSCR

   Question: Based on the following information, find the DSCR for each period individually and also using a look-back of

   Period                                                          -                         1           2
   CFADS                            -                                                       10          30
   Interest                                                                                 10           9
   Principal                                                           -                                 7

   Answer:
                                                www.videofinancialmodelling.com




d also using a look-back of two periods.

                      3            4        5
                     60           85       90
                      8            7        6
                     54           19       20
Example - CFADS

   Question: Find the Cash Flow Available for Debt Service based on the following inputs.
   Revenue                                                          50
   Expenses                                                       (10)
   Capital Expenditure                                            (15)
   Tax                                                             (5)
   Working Capital Movements                                       (2)
   Depreciation                                                   (10)

   Answer:
   CFADS                                                           18

Example - DSCR

   Question: Based on the following information, find the DSCR for each period individually and also using a look-back of two periods.

   Period                                                            -                          1                      2                          3           4         5
   CFADS                              -                                                        10                     30                         60          85        90
   Interest                                                                                    10                      9                          8           7         6
   Principal                                                             -                                             7                         54          19        20

   Answer:
   Debt Service                                                                                10                   16                            62          26        26
   Periodic DSCR                                                                             1.00                 1.88                          0.97        3.27      3.46
   Look-back DSCR                                                                                          1.538461538                   1.153846154   1.6477273 3.3653846

								
To top