Project Title : Financial Modeling and Analysis of 50 Flats Housing Project in Gurgaon, Haryana IN Techvardhan

Fantastic news! We've Found the answer you've been seeking!

Question:

Project Title : Financial Modeling and Analysis of 50 Flats Housing Project in Gurgaon, Haryana IN

Techvardhan Infra Pvt. Ltd (Any Company) "CLIENT" has acquired a piece of land near Gurugram HR and wants to develop it as a residential building having 50 flats of 900 sq. ft each.

They are expecting to sell the flats at a rate of Rs. 4000 / sq.ft. The expected CapEx is Rs. 8 Crore and OpEx is Rs. 50 Lacs / per annum for the whole project.

They are seeking a non-recourse debt (project financing) with 70:30 as D/E ratio from leading commercial banks in India as a 12 years term loan.

Please help me in preparing a financial model and analyse the cost, revenue and debt repayment along with finflow / cash flow analysis. Calculate equity IRR and DSCR.

Posted Date: May 18, 2024 11:17 PM

See More Questions

Use Lagrange multipliers to find the distance from the point (2, 0, -1) to the plane 6x - 2y + 7z+ 1 = 0. X
In a simplified model of an un-doped semiconductor, the actual distribution of energy states may be replaced by one in which there are N v , states in the valence band, all these states having the...
Discuss the concept of dynamic binding.
Current Ratio Loan Provision Assume that you are the controller of a small, growing sporting goods company. The prospects for your firm in the future are quite good; but like many other firms, it has...
At June 30, 2022, the end of its most recent fiscal year, Green River Computer Consultants post-closing trial balance was as follows: The company underwent a major expansion in July. New staff was...
1.Drawatreefortheequation:x6+x(2x3)=0 2.Drawatreefortheequation:3x+6=2(x2)+15
Arc-bot Technologies, manufacturers of six-axis, electric servo-driven robots, has experienced the cash flows shown in a shipping department. Determine the i*values between 0% and 100%. Year 0...
QUESTION 1 Indicate whether each concept is a function of financial accounting or managerial accounting: Accounting information is used primarily by internal decision makers Reports help stockholders...
Let E be the group of Euclidean functions. Define a map : E R by (f) = f(0). Show that this is a group homomorphism. Compute the kernel of the homomorphism.
Rayya Company purchases a machine for $151.200 on January 1, 2021. Straight-line depreciation is taken each year for four years assuming a seven-year life and no salvage value. The machine is sold on...
Assessment Task 2: Case Study The resources you will need for this assessment are: 1. Access to the internet2. Your Learning Guide3. PC, Word Processor, Printer4. Relevant legislation, regulations,...
Identify and briefly describe five different training techniques. Provide a detailed answer.
1 Using the new model, forecast the daily revenue when there are 10 retail stands and 15 food stands open, and approximately 1,500 women visiting. SUMMARY OUTPUT Dependent Variable: Daily Revenue ($)...
Frontland Advertising creates, plans, and handles advertising campaigns in a three-state area. Recently, Frontland had to replace an inexperienced office worker in charge of bookkeeping because of...
Summary of payroll procedures Soprano Construction Company uses the job order cost system. In recording payroll transactions, the following accounts are used: Cash Wages Payable FICA Tax Payable...
Accounting for bonus, vacation pay, and holiday pay The factory payroll for the week is $200,000, consisting of $140,000 earned by 100 direct laborers and $60,000 earned by 30 indirect laborers. The...
What are the advantages and disadvantages of the scattergraph method as compared to the high-low method?

Project Title : Financial Modeling and Analysis of 50 Flats Housing Project in Gurgaon, Haryana IN Techvardhan

Question:

Expert Answer:

Students also viewed these finance questions