Category: Finance

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)

I need a PowerPoint presentation on Intel Financial Results and Outlook 2022 – 2023.See attached template.

Financial Statement analysis, also otherwise known as financial analysis is a process that refers to analyzing the financial statements of an organization with the objective of ascertaining the financial situation of a business and thereafter making informed decisions regarding the business based on sound financial information. Task requirements:Choose two or more companies from same industry from FTSE 100. https://www.londonstockexchange.com/indices/ftse-100/constituents/table
Compare two or more years of their financial statements.
The analysis should be presented in tables and graphs such as pie, line and bars chart.
The analysis should be critically review and the consequences of historical data.
Professional experts conduct it in the field by assessing financial reports prepared for a financial year. So, what is financial statement analysis? It studies accounting ratios involved in financial transactions mentioned in a balance sheet.The following ratios are included in a financial statement analysis:Asset utilization ratioLeverage ratioValuation ratioProfitability ratioLiquidity ratioMarket Prospect RatiosMarket benchmarksFinancial Statement Analysis for Kier Group PLC.pdf
Assignment layout.docx
Assignment Brief.docx

I’ve attached the project instructions, and an example given by the teacher, don’t use any data from example in the project, just more as what a graph can look like. My assigned developed country is canada, my assigned developing country is mexico.

The cash conversion cycle (CCC) measures how many days it takes a company to receive cash from a customer from its initial cash outlay for inventory. For example, a typical retailer buys inventory on credit from its vendors. When the inventory is purchased, a payable is established, but cash isn’t actually paid for some time. The CCC is most effective with retail-type companies which have inventories. Consulting, software, insurance companies are example where the CCC isn’t useful. The cash cycle has three distinct parts. The first part represents the current inventory level, the second part represents current sales and the amount of time it takes to collect cash from sales on account and the third part represents current outstanding payables. The lower the cash cycle the better, so a negative cash cycle is very desirable. One of the ways a company can reduce the time to collect cash from sales on account is through accounts receivable or invoice factoring.
Point your browser to www.quicksprout.com and scroll to “Finance” and “Compare the Best Invoice Factoring Companies”, click on the link and you will see, The 9 Best Invoice Factoring Companies of 2023. Your assignment is to explore the this site or the Web and other sources to answer the following questions: 1) What is factoring (accounts receivable factoring), but not a definition per se, what is the purpose, what does it do, 2) How does the process of factoring work (describe steps in a factoring process, use a graph as well) and 3) if you owned a business, would you use a factoring service? What are the advantages and/or disadvantages?
Reflection – the students also should include a paragraph in the initial response in their own words reflecting on specifically what they learned from the assignment and how they think they could apply what they learned in the current environment or workplace.

You should address the following:
1- Your academic interests and reasons for applying to this programme. (here is the website: https://www.ucl.ac.uk/prospective-students/graduate/taught-degrees/finance-msc)
2-Your career objectives and any relevant non-academic achievements as well as any publications. (something like earning this degree will help me enhance my skills as i am working as a budget analyst for 5 years now and getting taught by the excellent faculty of UCL.
3- Outline any other relevant experience including attendance at specialist workshops or short courses. attended a one-week course in 2020 about how to build a clear indicators to track public development projects in order to know why we fail to complete some of those projects and figure out what we can do to overcome challenges.

An analysis of your investigation into risk premia, including the results for Portfolio 1 & 3 and the associated background literature, and the analysis of the tracking portfolios and their ability to replicate the allocated factor HML (High minus Low) . I have Included a sample report (sample word doc) on a sample portfolio (sample excel file) that is also tracking the HML factor. Also included are the excel portfolio workings for Portfolio 1 and 3 and statistical summary’s of the data in tables at the bottom of the portfolio summary tabs- please use the data in the reponse. 1 word doc page on Portfolio 1 and 1 word doc page on portfolio 3

Please follow the REQUIREMENT document and the EXAMPLE REPORT document to write.
You need to choose three Asian stocks that could be selected based on your strategy and three that need to be avoided based on your plan. These stocks should be selected from the largest ten stocks in each Asian country from Yahoo Finance.
You should develop a strategy criterion that needs to be formed by several aspects (law and finance- ownership, family capitalism, corporate groups, state capitalism, and financial crisis, etc,).
Some readings I have already uploaded, pls read them and use some of them in the report. DO use at least three of them.
the reference style is Harvard.
If there is any confusion or trouble, pls contact me via the website. Thank you.

Need help affording my electric bill
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)

Instructions will be uploaded later.
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)