Category: Finance

  • Real Estate Closing Disclosure worksheet

    Instructions

    BUSN220 Week 6 / Assignment #2

    Conduct a Google search for a blank Closing Disclosure form PDF and use that document

    Using the information provided below, calculate the buyer’s and seller’s costs and credits as they would appear on the Closing Disclosure Form (CD). You are required to use the actual CD form posted below; although you will not have information for all the blanks. Some of the information given in the Assignment will need to be used to figure out some of the answers. You may want to look at the example before filling out the CD with fields. If you need help, it is important to ask your instructor well before the assignment is due.

    The goal is to come up with the correct amount the Buyer needs to bring to closing, and the correct amount the Seller would receive at closing. Keep in mind the calculations are based on how you fill in the blanks. One miscalculation can cause you to miss the goal.

    First, please determine which party is responsible for each item. Upon completion, upload your CD to the Assignments area of the classroom.

    When calculating these costs, the complications can occur when you figure the taxes and shared lender fees, etc. Do your best and let me know if you have any questions.

    No prepayment penalty

    Property located in Virginia

    Closing Date: October 15

    First payment due: December 1

    Sales Price: $400,000

    Earnest money deposit: $5,000

    Fannie Mae Mortgage

    Down payment: 20%

    New loan @ 6.50% interest, for 30 years

    Escrow (impound) of two months

    Annual property taxes: $2,400, paid through December 31 (Escrow amount included in monthly payment).

    Tax period is January 1 December 31

    Homeowners insurance: $1800 for one-year policy (Escrow amount included in monthly payment).

    The seller paid the taxes for the year on October 1.

    Owner’s title policy: $250

    Lenders title policy: $750

    Real estate broker commission: 6 percent

    Existing loan to be paid off: $125,000

    Survey $125 Paid by seller

    Recording fees charged to buyer: $75

    Lender fees charged to buyer: $1,100

    Transfer tax: $180 paid by seller

    Termite inspection: $125

    Home Inspection: $500

    Roof repair by seller: $2,100

    Homeowner warranty provided by seller: $500

    Seller’s contribution to sale: $2,500

    This website gives a good explanation of the CD and all its parts.

    This video may help you put the numbers in the correct line:

    For this assignment, you are not expected to complete the example Closing Disclosure forms linked in the assignment instructions. Those links are examples only and are not editable

    To complete the assignment, you should do one of the following:

    Conduct a Google search for a blank Closing Disclosure form PDF and use that document

    Use a blank Closing Disclosure template you locate independently that matches the standard CD format

    You will not have information for every field on the form. That is expected. Complete as much of the form as possible based on the assignment scenario and focus on accuracy and formatting.

    Adobe Reader is required for this assignment.

  • Personal financial planning and budgeting for relocation

    Please see attachments for instructions

    Attached Files (PDF/DOCX): cf_assessment_2_word_template.docx, Instructions.docx

    Note: Content extraction from these files is restricted, please review them manually.

  • Case Study

    Easy Case study

    Requirements: as long as needed

  • write down the steps to calculate the duration and convexity…

    (a)If you are given a simple OAS model (such as the the Excel model provided in class), write down the steps to calculate the duration and convexity of each type of asset i.e. the Mortgage passthrough, the PO and the IO

    Requirements: one day

  • Choose an asset that you like on which options are available…

    Choose an asset that you like on which options are available.Select ITM, ATM, and OTM with at least three different expiration datesCheck the asset price and its options that you have selected on a daily basisGraph the asset and its options prices and their time values.What statements you can make:

    1.Compare the changes in option prices to the changes in the price of the underlying asset.

    2.How does time value change over time?

    Must include the analysis reports, Excel calculation and at least 5 graphs.

    Requirements: Papers , excel caculation and praghs

  • Finance – Reaction Paper 2

    Use the link below to access a newspaper article and write a discussion post on it. Make it opinionated.

    https://www.tribune242.com/news/2026/jan/23/vat-cut-goes-against-grain-of-food-security/?news

  • explination about ive passive equity portfolio

    CALF 3 2026

    Explain five passive equity portfolio management strategies and discuss how you will select an ETF as part of your strategy. Illustrate and conclude your answer with an application. Test your strategies and recommendations via Capital.com or any other platform. You can also use Capital IQ to calculate the historical performance and calculate the long-term performance. Students are free to choose any technique including buy and hold or tracking an index. For the ETF section, students can test whether arbitrage exists by using Intraday Net Asset Value (iNAV).

    Students are expected to demonstrate the importance of ESG data whilst implementing preferably 5 passive equity portfolio management strategies.

    Analyze the importance of a taxonomy establishing a list of environmentally sustainable economic activities and its role in aiding sustainable investment.

    Discuss the role ESG data plays in equity portfolio management.

    Check ESG Rating Agencies such as Sustainalytics that provides ESG ratings and research to help investors understand and manage ESG risks and opportunities. MSCI evaluates companies on ESG factors and assigns ratings that help investors make informed decisions. Other evidence will be compliance to green bonds or ISO 14001.

    Hint:

    Passive portfolio strategies: Buy and hold & indexing

    Three basic techniques: Full replication, Sampling & Quadratic optimization or programming

    Must show tracking error

    Explain the Top-Down Investment Process used for example the volatility caused by US president such as Trump.

    Strategic Asset Allocation (example weights)

    Investor Profile

    Equity

    Bonds

    Alternatives

    Cash

    Conservative

    30%

    55%

    10%

    5%

    Balanced

    50%

    35%

    10%

    5%

    Aggressive

    75%

    15%

    10%

    Limits to Arbitrage

    Price Discovery and Informational Efficiency of ETFs

    ETF as a Cause of Liquidity Crisis for its Underlying Constituents

    Creation and Redemption through Fund Flows and Price Manipulation

    Volatility and Volatility Spillover

    Sector rotation strategies (Low PE for undervalued stock, growth stocks or others)

    Style (value, growth, income, momentum, index (passive), quantitative, ESG, contrarian, sector, theme or others)

    The structure of the report must follow the following guidelines.

  • Executive summary or synopsis
  • Introduction
  • Market view
  • Trading strategy
  • Performance analysis
  • Conclusion.
  • -Buy & Hold strategy, 3 for Index (full replication, sampling and optimization) and one for ETF. This will be five.
  • Requirements: 1200 words max

  • (Financial Engineering and Derivative Securities) Choose an…

    Choose an asset that you like on which options are available.Select ITM, ATM, and OTM with at least three different expiration dates.

    Check the asset price and its options that you have selected on a daily basis.

    Graph the asset and its options prices and their time values.

    What statements you can make:

    1.Compare the changes in option prices to the changes in the price of the underlying asset.

    2.How does time value change over time?

    Requirements: Required with calculation process of Excel and graphs

  • Finance Question

    FIN3400 Capital Budgeting Assignment

    Objective:

    The objective of this assignment is to help you understand the process a company uses to determine the merits of a capital project. Companies use Net Present Value (NPV) and Internal Rate of Return (IRR) to determine if a project meets the required return. This assignment ties into SLO 10- Finance – Students will demonstrate the integration of specific knowledge and business skills in finance such as investment, financial policy, and commercial bank management. of creating an Income Statement, perform a scenario analysis, and calculate important financial metrics such as Net Present Value (NPV), Internal Rate of Return (IRR), and perform sensitivity analysis. You will apply these concepts to a hypothetical business project and analyze the results in different scenarios.

    Part 1: Create a Simple Income Statement for Each of the Three Scenarios

    1. Introduction to the Business Scenario: Imagine you are starting a small business that sells a product. Below are the basic assumptions for an optimistic, realistic, and pessimistic scenario:

    Assumptions

    Optimistic

    Realistic

    Pessimistic

    Units

    5,000

    4,500

    4,000

    Sales Price

    $95.00

    $90.00

    $85.00

    Variable Costs

    $60.00

    $64.00

    $68.00

    Depreciation

    $10,000

    $10,000

    $10,000

    Interest Expense

    $2,000

    $2,000

    $2,000

    Fixed Costs

    $25,000

    $25,000

    $25,000

    Tax Rate

    25.00%

    25.00%

    25.00%

    1. Income Statement Format: Based on the above assumptions, create Income Statements for your business for each of these scenarios. Include the following line items:
    • Sales
    • Variable Costs
    • Gross Profit
    • Depreciation
    • Fixed Costs
    • Operating Income
    • Interest Expense
    • Taxable Income
    • Taxes
    • Net Income

    Instructions:

    • Fill out the income statement using the values provided.
    • Calculate the missing values such as Gross Profit, Operating Profit, Taxable Income, Taxes, and Net Income.
    • Calculate Operating Cash Flow

    Part 2: Scenario Analysis Using NPV and IRR

    1. Project Assumptions:

    Assumptions for the Project:

    • Initial Investment (Year 0): $200,000.00
    • Discount Rate: The WACC for the company is 12%.
    • Project Life: 5 years
    1. NPV and IRR Calculations: Once Income Statements have been completed, calculate the NPV and IRR for each of the scenarios. You may use the Excel function keys or mathematical formulas. Be sure to show your work. Use operating cash flow for your cash inflows. Assume the cash flow remains constant for the 5-year life of the project.

    Part 3: Sensitivity Analysis

    1. Purpose of Sensitivity Analysis: Sensitivity analysis is used to understand how the NPV and IRR are affected by changes in key assumptions. In this case, you will vary both the price and variable costs.
    2. Instructions:
    • Perform sensitivity analysis on the following variables:
    • Projected Cash Flows: Vary the price of the project using pessimistic values. Construct the New Income Statement for this sensitivity variable.
    • Projected Variable Costs: Vary the variable costs of the project using pessimistic values. Construct the New Income Statement for this sensitivity variable.
    • For each change, recalculate the NPV and IRR.
    • Use the What If Analysis to construct a data table for each change.
    1. Analysis:
    • Discuss the results of the sensitivity analysis: How does changing each variable affect the NPV and IRR? Which assumptions have the greatest impact on the results?
    • Based on all the information presented conclude as to the viability of the project. Be sure to defend your decision.

    Deliverables:

    1. Income Statement: Include completed Income Statements for each of three scenarios and two sensitivity analysis assumptions. Use the correct format.
    2. NPV and IRR Calculations: Provide NPV and IRR calculations for each of three scenarios and two sensitivity analysis assumptions. Be sure to show your work.
    3. Sensitivity Analysis Table: Present a table that shows the results of the sensitivity analysis for varying price and variable cost assumptions.
    4. Analysis Report: Write a short report (300 500 words) summarizing your findings from the sensitivity analysis and ultimate project decision. Highlight key takeaways about how each factor influences the project’s financial metrics.

    Submission Guidelines:

    • All Income Statements, NPV calculations, and IRR calculations must be submitted on an Excel spreadsheet.
    • All analysis must be submitted on a Word document using SafeAssign.
    • Be sure to explain the steps you took to complete each part of the assignment.

    Requirements: Excel and Word

    Requirements: Excel and Word