Amortization - Study guides, Class notes & Summaries

Original loan is a - correct answer PVA The PVA - correct answer is the amount the bank is willing to "give" me in exchange for my stream of future payments. Loan amortization schedule is useful for... - correct answer Telling how much of each payment is principal and how much is interest. Depreciation - correct answer Spreads a TANGIB...

Excel Crash Course Exam from Wall Street Prep 2022 - Wall Street Prep Questions And Answers Updated 2022 Instructions: Questions 1-4 use the financial model on tab Q1-4 in the Exam Workbook. Complete the model by filling in the blank cells before answering the question below. Answers should be rounded to the nearest whole number, comma separating 000s, NOT written in currency format. So if the answer is $5,505,210.50, you would input 5,505,210. 1. What is forecast Revenue in 2017? 13...

100% A+ ANSWER SHEET - WALL STREET PREP EXCEL CRASH COURSE RETAKE EXAM ANSWER SHEET 48/48 **2024** this document shows all the answers to the wall street prep excel crash course retake exam to help you prepare for your best chances of passing and receiving your certification. ____________________________ Questions on the exam....... Question 1 Instructions: Questions 1-4 use the financial model on tab Q1-4 in the Exam Workbook. Complete the model by filling in the blank cells before ans...

Which of the following best describes a borrower obtaining a loan where the payment includes principal, interest, taxes and insurance? - correct answer Answer: Budget Loan Explanation: A lender prefers a budget mortgage as real property taxes have a higher priority over other liens and the collateral for the loan is protected when it is insured. A fully amortizing loan means that the loan will have a zero balance at the end of the loan repayment term. A pa...

Amortize - correct answer pay down debt through payments over time Amortization Schedule - correct answer table of numbers underlying the balance and payment graphs, namely the loan balance over time and the payment split into interest and principal Prepayment Risk - correct answer risk involved with the premature return of principal on a fixed income security or loan default -...

4 categories of long-lived assets: - correct answer land, land improvements, buildings, equipment` Three characteristics: - correct answer physical substance, used in operations, not for sale to customers Operating expenditures: are/and on the journal are - correct answer costs incurred that only benefit the current period/expensed Capital expenditures: def/are included in - co...

1. Breakeven Point?: total cost = total revenue 2. Working capital ratio: current assets / current liabilities 3. Acid-test (quick) ratio: (cash + AR + short-term investments) / current liabilities 4. debt to assets ratio: total liabilities/total assets 5. FTE (full time equivalent): total number of hours per employee in a week / 40 (i.e. 12+14+40+30 div. by 40) 6. Profit margin: NOI/Tot. Revenue. Defined as "income to sales. 2 types, gross prof margin and net prof margin) 7. Net Operat...

Questions 1-4 use the financial model on tab Q1-4 in the Exam Workbook. Complete the model by filling in the blank cells before answering the question below. Answers should be rounded to the nearest whole number, comma separating 000s, NOT written in currency format. So if the answer is $5,505,210.50, you would input 5,505,210. 1. What is forecast Revenue in 2017? 13,642,021 2. What is forecast Net Income in 2016? 925,777 3. If Depreciation&Amortization as a % of Capital Expenditures is changed ...

Instructions: Questions 1-4 use the financial model on tab Q1-4 in the Exam Workbook . Complete the model by filling in the blank cells before answering the question below. Answers should be rounded to the nearest whole number, comma separating 000s, NOT written in currency format. So if the answer is $5,505,210.50, you would input 5,505,210. 1. What is forecast Revenue in 2017? 13,642,021 2. What is forecast Net Income in 2016? 925,777 3. If Depreciation&Amortization as a % of Capital Expenditu...

1. What is forecast Revenue in 2017? 13,642,021 2. What is forecast Net Income in 2016? 925,777 3. If Depreciation&Amortization as a % of Capital Expenditures is changed to 30%, what is Net Income in 2017? 1,123,438 4. What is the EBITDA % Margin in 2018? 17.1% Instructions: Questions 5-19 use the data table on tab Q5-19 in the Exam Workbook. We strongly recommend you analyze this data with the aid of a pivot table. You may also benefit from adding some extra calculation columns to the d...