Finance (FINANCE)

FINANCE 301 – {CORPORATION FINANCE} PREP ACTUAL EXAM QUESTIONS BY PROF SARA SMIAROWSKI FINANCE 301 QUIZ 1 1. You are considering buying a condo in Boston for $900,000. You plan to make a down payment of $90,000 and finance $810,000 with a 25 year loan. If the interest rate is 5.25%, what is the monthly payment, assuming you'll pay the mortgage at the end of every month. ANSWER: FVA = A(FVIFA); where r/12 and n*12 FVIFA = [(1+r)^n - 1]/r 2. At the reading of the will, you learn that y...

Excel Crash Course Exam from Wall Street Prep-wall Street Prep Questions And Answers Updated 2022/2023. 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. ...

Excel Crash Course Exam from Wall Street Prep-wall Street Prep Questions And Answers Updated 2022/2023. 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. ...

This document contains the full Excel Crash Course Exam from Wall Street Prep, complete with all questions and A+ graded answers. It covers essential Excel skills for financial modeling, including pivot tables, VLOOKUP and HLOOKUP functions, OFFSET and MATCH formulas, NPV and IRR calculations, and financial data analysis using pivot tables and data tables. The material also includes applied finance exercises such as forecasting revenue, calculating EBITDA margins, and evaluating investment retur...

Excel Crash Course Exam from Wall Street Prep-wall Street Prep Questions And Answers Updated 2022/2023. 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,...

Review: Excel Crash Course 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 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. What is forecast Revenue in 2017? Question 2 Instructions: See question 1. What is forecast Net Income in 2016? Q...