Order the descriptions below to match the sequence in which an integrated financial statement model is built. Build the supporting schedules Input histroical Data Project the financial statements Select one: A. step 3, 1.2 B. step 2,1,3 C. Step 1,2,3 D. Step 1,3,2 Cash on the balance sheet pulls from which of the following ? Select one: A. PP&E schedule B. Cash flow statement C. Debt Schedule D. Income statement When projecting the income statement, which items are left blank because they are calculated using supporting schedules? Select one or more: A. Interest Expense B. Depreciation C. Tax Rate D. Operating Expenses Which of the following statements is true as it relates to interest expense on the cash flow statement? Select one: A. Interest expense is listed under cash flow from financing activities. B. Interest expense is listed under cash flow from investing activities. C. Interest expense is not listed on the cash flow statement. D. Interest expense is a non-cash item that is added back When initially projecting the balance sheet, why is cash left blank? Select one: A. Because the supporting schedules are lacking B. Cash is not left blank. C. Cash must first be calculated on the cash flow statement D. Cash must first be calculated on the PP&E schedule Pick the best description of AR Days (accounts receivable days). Select one: A. The sum of invoiced balances due to the company B. The number of days it takes the company to pay suppliers. C. Accounts receivable balance for the last day of the accounting period. D. The number of days it takes the company to collect payment after a sale. What is the formula for AR Days (accounts receivable days)? Select one: A. (AR Balance) / (COGS/365) B. (AR Balance)/(365 / Revenue) C. (Revenue) / (AR Balance /365) D. (AR Balance) / (Revenue/365) What is the formula for AP days ( accounts payable days)? Select one: A. (AP Balance) / (COGS/365) B. (COGS)/(AP Balance /365) C. (AP Balance) / (Revenue / 365) D. (AP Balance)/(365 / Revenue) As an asset increases what impact will it have on cash Select one: A. Consumes cash B. Neutral impact C. Provide cash The circular reference created by to a broken model. a is one of the most common contributing factors Select one: A. Revenue B. Interest expense C. Operating expense D. Capital expenditure What Excel functionality is required to permit circular references in a model? Select one: A. Manual Worksheet Calculation B. Enable Multiple Calculation C. Enable Iterative Calculation D. Iterative Worksheet Calculation