Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A Big conglomerate which is operating in different sectors like Manufacturing, Travel, Mining, and Information Technology is planning to venture into Education sector. Chris, the

A Big conglomerate which is operating in different sectors like Manufacturing, Travel, Mining, and Information Technology is planning to venture into Education sector. Chris, the chairman of business group has a vision to set up Institutes which are schools (Pre-Primary, Primary, and Secondary), colleges (Undergraduate) and Training places (For competitive exams and IT skill development) across different cities across India. Since Chris belongs to Bengaluru and his company headquarters is in same city, he wants to start the new business line from this city and in 3 years time he wants to expand it to other tier 1 cities. He expects to have at least 100 institutes by end of 5th year. Sources of Funds The Business group is committed to provide INR 50 crores for this project as equity spread across 3 years. For remaining funds Chris is planning to approach Banks to provide debts. Revenue Sources Fee from students, Grants from Business group Trust, Donations Model: Please build a model for a period of 10 years with at least the first three years broken down into quarters. Please provide the necessary performance indicators to be measured for checking the health of this sector. Please make necessary assumptions wherever necessary apart from the above and state them clearly. Model should include 3 basic financial statements i.e. P&L, Cash flow statement and Balance sheet and any other required schedules. Please see below the expectations from this exercise: Easy to use Design the model for the user to navigate easily. Easy to understand The user should be able to easily understand the model Reliable The model should give out reliable answers for any inputs Other instructions Clearly defined inputs, calculations, and outputs No hard coding Cells should have appropriate units (where even applicable) Color coding of different types of cells Show the model on excel sheet and calculations

POST THE PICTURE OF CALCULATIONS AND ASSUMPTIONS in EXCEL SHEET WHICH INCLUDES BALANCE SHEET, INCOME STATEMENT, AND CASH FLOW numbers and values I need the picture or excel file attached. to this solution, not just the steps, thanks,

Attach the solved case study on excel sheet with numbers on the model

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting Second Custom Edition For The University Of Central Florida

Authors: Walter T. Jr, Horngren Harrison

2nd Custom Edition

0536986002, 978-0536986009

More Books

Students also viewed these Accounting questions