Category: Finance

This a group assignment, but the part that I was assigned is capital structure analysis. For first two parts, reliable data is needed.

create Fitech Based Website in Wix.com In this assignment, Each student need to create his own Fintech Related Website for his own in Wix.com. Then share the link here on LMS. This assignment carry 5 points. Video link https://www.youtube.com/watch?v=3F

The completed project should include the information listed below: Provide an introduction to the companies involved in the merger or acquisition. Include the companies’ background information and the reasons for the merger. Evaluate the financial statements of both companies (balance sheet, income statement, cash flow statement). Evaluate the potential and actual risks that occurred during the merger and what the companies could have done differently to mitigate these risks. Discuss the companies’ management of human capital in the merger or acquisition. Evaluate the soundness of the company’s financial policies after the merger (e.g., capital structure, debt, leverage, dividend policy, enterprise risk management, and others.) based on the material covered during class. Include a synopsis of your findings, including your recommendations and rationale for whether the merger or acquisition was beneficial to both companies and your recommendation on best practices for moving forward.

1- (Adjusting Excel File ) In the Excel File add graphs the same as the graphs that are included in the ( Example of the Word file ) “Our graphs must represent our own data which is in the income statement sheet table. 2- make a Word file and use the same ‘format” as the Word file same structure but for sure content will be different because i use different company and interpret all graphs that you make it in Excel file in Word file, and follow this structure when you making the word file
Table of content:
Introduction2
Company description2
Ratios analysis 4
Financial Recommendations10
Financial risk12
Conclusion14
References16

write a final report for my coop training program
I need A final report with approximately 3000 words for my coop training program in the finance department in Al-Rajhi Capital company , also a short presentation to present to explain my work in the department
I have shared my previous weekly reports to know the tasks I did and the rest is explained in the report cover page.
For The company section you can use the company’s website, I have added a pic of the organization chart to use

A Google sheet financial plan, instructions are scarce, but should be on the sheets, several columns, honestly this assignment might not be doable because there are recorded lectures attached to this assignment that make it more understandable

Solve this problem with all the paragraphs in it
Important Info
The order was placed through a short procedure (customer skipped some order details).
Please clarify some paper details before starting to work on the order.
Type of paper and subject
Number of sources and formatting style
Type of service (writing, rewriting, etc)

A report has to be written as per assignment document requirements attached on the case study financials (also attached). Please note that there are 2 parts A and B which both have to answered with CALCULATIONS, and for each part at least 1000 words has to be written. Could you please review the material and advise how much extra I have to pay for the calculations which I could not select in the list of the report assignment.

Name of supervisor : Misfer AL Zahrani ( trainee organisation )
Name of supervisor at university ( female ) Asma Al Hazmi
Establishment name : Misfer ALzahrani est for construction The report should be submitted within two weeks after you finish your Co-op training Program. In addition, the report should be approximately 3000 – 4000, single –spaced and consider taking the following format General instructions for writing the final report: The report must be written in English language.
The word limit is 3000-4000.

GBI has sourced a freehold plot in Berlin-Pankow. Please see attached the investment memorandum (the “IM”) on Project ASTA. GBI considers to acquire the plot but needs further analysis regarding the residential concept to maximize the value.
We would like you to produce a cash flow model for the potential acquisition of this plot and a short investment memo (max. 10 slides), summarizing your analysis of and recommendation for the opportunity with the following content:
Please incorporate the following assumptions into your analysis of Project ASTA (Base Case):
Timeline
• Acquisition Date: June 30, 2024
• Building Permit: December 31, 2024
• Construction Start: July 1, 2025
• Practical Completion: determine a reasonable date
Development Budget / All-In Costs
• Development Budget (excluding Acquisition Price, Real Estate Transfer Tax, Closing Costs and Financing Costs): assume a total budget of €4,000/sqm incl. VAT
• Financing: assume the plot (acquisition loan) and the development budget (construction loan) is acquired with 65.0% LTC, priced at 6.5% All-In interest rate, 1.0% arrangement fee and 3.0% commitment fee
• Tax: assume a Capital Gains Tax Rate of 31.0% at Exit; assume that the plot is acquired in an asset deal at a Real Estate Transfer Tax of 6.0% applies
Rent / Exit
• ERV: determine ERV by using public available information
• Exit Cap Rate: determine the exit cap rate by using public available information
Please fulfil the following tasks and provide the requested information below in the short investment memo:
Task 1)
• Please provide a high-level assessment and verify the given GLA (BGF) in the IM whether it seems to be approvable by local authorities
Task 2)
Please provide …
• a brief macro / micro location desсrіption / analysis
• letting comparables
• an overview of your exit assumptions / considerations (market intel – comps, yields)
• business plan considerations / assumptions
Task 3) Trader Developer Strategy
• Scenario 1: Sale at Practical Completion
Please include your recommendation on the price at which you would buy the plot based on the information in the IM (including areas), above mentioned assumptions and calculate an appropriate target IRR / money multiple and provide a sensitivity table that shows IRR and money multiple based on different purchase prices and exit yields
Please also compile any other key metrics you see necessary to evaluate the investment opportunity in a holistic manner (basis, profit, income, yield metrics etc.)
• Scenario 2: Sale via Forward Funding
You have sold the project in a forward funding to an investor on start of construction
Apply the following Instalments for the forward funding proceeds (instead of securing construction loan during the construction phase; you repay the acquisition loan once first instalment is received; no forward funding coupon to the investor)
1st Instalment: 30.0%, Construction Start Date
Final Instalment: 10.0%, one quarter after Practical Completion
Remaining 60.0% of Instalments will be pro-rata quarterly distributed to GBI between the first and final instalment
Please include your recommendation on the price at which you would buy the plot based on the information in the IM (including areas), above mentioned assumptions and calculate an appropriate target IRR / money multiple
Please also compile any other key metrics you see necessary to evaluate the investment opportunity in a holistic manner (basis, profit, income, yield metrics etc.)
Please send across the model (Excel) and short investment memo (PDF) by May 12th, 2024.
The investment memo should include all necessary information (incl. CF and all relevant financial metrics) that you need to make your case for the investment and should be used for presenting and discussing the opportunity with a selection of members from our team.
P.S. Please find attached an example cash flow model. Feel free to use this cash flow template, adjust this template or to create your own. It is important that your assumptions will be shown clearly and be connected to the cash flow model (dashboard / input sheet / assumptions overview).
Important Info
The order was placed through a short procedure (customer skipped some order details).
Please clarify some paper details before starting to work on the order.
Type of paper and subject
Number of sources and formatting style
Type of service (writing, rewriting, etc)