Based on this, need a well-conceived and detailed table of contents with a logical design, as well as an introduction at the end of the table of contents and Chapter 2, Theoretical Background. I can write the rest myself. The required literature is books and scientific journals, and other “papers” should be avoided as much as possible.
Category: Finance
Submission Details: 1 Due Date and Time: January 1, 2025. 2 Maximum Upload Attem
Submission Details: 1 Due Date and Time: January 1, 2025. 2 Maximum Upload Attempts: 2 3 File Types: ◦ Part 1: Excel file with computations. ◦ Part 2: Report in Word. Part 1 – Excel File (50 Marks) Perform the following computations using Excel formulas and functions: • a) Monthly mortgage payments calculation. • b) Initial cash outflows for purchasing the property. • c) Monthly opportunity cost of using initial funds. • d) Present value (PV) of cash outflows for 10 years (buy decision) vs PV of rent. • e) Mortgage principal outstanding at the end of 10 years. • f) Net gain/loss from selling the property after 10 years under these scenarios: ◦ i. No change in property value. ◦ ii. Property value increases by 10%. ◦ iii. Property value decreases by 10%. ◦ iv. Property value and rent increase by 0.15% monthly. Ensure all computations are driven by formulas/functions, not hardcoded values. Part 2 – Report & Recommendation Create a professional report following these guidelines: 1 Format: ◦ Arial font, size 11. ◦ Line spacing: 1.5. ◦ Margins: Normal. ◦ Length: 2-3 pages (excluding tables and references). 2 Content: ◦ Analysis Description: Briefly explain the computations performed. (10 marks) ◦ Results Summary: Highlight key quantitative findings from Part 1. (5 marks) ◦ Recommendation: Offer advice to the Wongs based on the quantitative insights. (20 marks) ◦ Qualitative Considerations: Discuss non-numerical factors impacting the decision (e.g., lifestyle, market trends, flexibility). (10 marks) ◦ Presentation Quality: Ensure the report is clear, concise, and professionally formatted. (5 marks)
page 1 RSM3 — RSM3 Task 1: Becoming an Effective Values-Based Leader Values-Base
page 1 RSM3 — RSM3 Task 1: Becoming an Effective Values-Based Leader
Values-Based Leadership — D253
page RSM3 — RSM3 Task 2: Communicating Your Leadership Vision
Values-Based Leadership — D253
page 1 RSM3 — RSM3 Task 1: Becoming an Effective Values-Based Leader Values-Base
page 1 RSM3 — RSM3 Task 1: Becoming an Effective Values-Based Leader
Values-Based Leadership — D253
page RSM3 — RSM3 Task 2: Communicating Your Leadership Vision
Values-Based Leadership — D253
Select an article in the news, or from another reputable source. Write a brief s
Select an article in the news, or from another reputable source. Write a brief summary of the article, and then describe how you would analyze that article using some of the tools/concepts from finance that we’ve learned in our class. Your analysis should be brief, but informative. You can keep it to 2 pages, if you’re using double spacing, or 1 page if you’re single spacing.
PreviousNext
Find a new or existing home that you would hypothetically like to buy. (Use any
Find a new or existing home that you would hypothetically like to buy. (Use any source you like: for example, realtor.com or zillow.com.) In order to make this more useful, you might focus on a house in an area where you think you might live someday. Also, think about a home in a price range that might be feasible for you in a few years. Show your work to receive partial credit for incorrect answers. (See the video, slides, and Excel file from the first 32 minutes of class on 10/28/24 to see two examples of this. You can also look at an Excel file with 3 examplesof these calculations.)
[Note: after ~9:00AM on Mon., Nov. 4, when the answer file is posted, new submissions will earn a maximum of 50% credit.]
Answer these 11 questions, and show some of your work for partial credit:
What is the address of the property?
What do you think the final sales price will be? (it’s up to you; you can agree to the asking price if you’d like!) This is the price to use as a starting point for the questions below.
How much money will you have to bring to closing to pay for CLOSING COSTS (including prepaids)? (Assume that closing costs and prepaids together total to 5% of the sales price)
How much money will you have to bring to closing to pay for the DOWN PAYMENT? (Assume that you make a 6% down payment that your lender requires)
How much will you have to bring to closing in total? (Add #3 and #4 together)
How much will the total mortgage amount be? (In other words, what will the loan amount or principal be? Hint: Note that in this exercise, you cannot borrow for closing costs or, by definition, the down payment. However, ONLY the down payment reduces the amount you are going to borrow.)
How much will your monthly payment be for just the principal and interest (a combined PMT number, or “PI”) for the loan? The loan will be a fixed-rate 30-year mortgage at 7.5% interest that will be compounded and paid monthly.
How much will your monthly property tax payments be, assuming a property tax rate equivalent to 2% of the home value each year? (Hint: use the property value, not the mortgage amount, to begin with, and be sure to convert to monthly amounts. These amounts are paid into your escrow account with your lender.)
How much will your monthly insurance payments be, assuming an insurance cost equivalent to 0.8% of the home value each year? (Hint: use the property value, not the mortgage amount, to begin with, and be sure to convert to monthlyamounts. These amounts are paid into your escrow account with your lender. Also pay attention to your decimal places; in this problem and for many people in Texas, your insurance payments should cost less than your property tax payments! However, that may be changing in the near future…)
Including all four PITI components, what will the full monthly mortgage payment be? (#7 + #8 + #9)
If your lender requires your monthly mortgage payment (PITI) to be no greater than 28% of your monthly gross income, and assuming that your other debt payments are small, what is the lowest annual gross income you could have and still purchase this house (according to your lender)?
(Hint: I can explain the algebra to you if you would like, but start with the answer from #10, multiply it by 12 to get your annual mortgage payment, and then divide that result by 0.28 to get the minimum annual gross income you would need.)
Hi how are you? I have an assignment with 3 questions, I need a clear answer wi
Hi
how are you?
I have an assignment with 3 questions, I need a clear answer with a 0% match. Thank you.
You are to do a 3 page Detailed financial analysis of The Bank of The Bahamas—
You are to do a 3 page Detailed financial analysis of The Bank of The Bahamas— tear the numbers apart: income statement, balance sheet, capital structure, dividend policy, capital budgeting expenditures, R&D, pension liabilities, impact of union contracts, credit rating, funding requirements, ROE, ROA, stock price, growth, legal problems, etc. What’s good? What’s bad?
Paper is to be written in APA format with subheadings the charts/graphs are not to be included in the paper but in the Power point presentation only (provide speaker notes). Plagiarism and AI is not acceptable and use up to 3 citations.
Please see the attached instructions. Before you begin working on the assignmen
Please see the attached instructions. Before you begin working on the assignment, be sure to review the investment information for the Fidelity® Large Cap Stock Fund. https://fundresearch.fidelity.com/mutual-funds/summary/315912402
Valuation – Using both discount cash flow and multiple methods, you will estimat
Valuation – Using both discount cash flow and multiple methods, you will estimate the current
value of the stock and its value one year from now. You will need to compare your forecasts
with other analysts and explain why yours deviate from theirs if by more than 5%. Finally, you
need to compare your expected total return to the expected return to a Treasury security of
similar maturity and divide their difference by the volatility of your stock over the past two
years. Similarly, obtain an estimate of the expected return to the S&P 500 over the next year and
divide the difference between it and the expected return to a Treasury security of a similar
maturity with an estimate of the volatility of the S&P 500 over the past two year. Interpret the
implications of these two ratios and their comparison.
Presentations should be no longer than 10 minutes, but questions can be asked during
presentations and so each presentation + questions is limited to 15 minutes.