A new Company in Training domain projects an initial enrolment of 140 participants in the first...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A new Company in Training domain projects an initial enrolment of 140 participants in the first year, with an average fees of Rs. 18,000 p.a., per participant. It expects a 10% of Gross Fees revenue by way of other income every year. It expects the enrolment to increase by 10% every year, while the average fees are expected to align with the GDP Growth. GDP is expected to grow @6% on a year on year basis for the next 10 years. Its other project related parameters, outlays and expenses are as follows. A. Non Current Assets DESCRIPTION QTY Computers & accessories Fan & Light fitting Tables, Chairs and File racks at office TOTAL ŞI No 1 2 4 4 B. Deposits Training hall that is to be hired on a lease rent of Rs. 10,000 (Rs. In '00000) Sr. No Description 3 4 Price ('00000) Conveyance Expenses Bank Loans Processing Fees Legal Charges 0.32 0.03 RENTAL DEPOSITS C. Pre-Operative Expenses The business entity estimates the pre-operative expenses as below. Nature of Expense Rs. (in '00000s) Salary and Wages, Telephone Expenses 0.30 0.25 0.40 0.40 Amount 1.50 Cost of Equipment ('00000) 1.28 0.10 0.51 1.90 D. Capital Structure The promoters plan to structure the capital on a 2:1 Debt Equity ratio. Long Term Loans can be raised at an interest cost of 12% p.a. Principal amount of the Loan is repayable on a five year period, on a quarterly instalment basis, with a six month holiday period. E. Working Capital Structure The business expects to maintain its current assets / current liabilities as below. Nature Inventory of Study Materials Creditors Proportion / Ratio 0.25 Requirement 1.50 Months F. Study Materials & Reference Books: Study Materials costing Rs. 200 per subject would be distributed. The same is considered as part of the fees. One copy of reference book based on a strength of 200 participants would be procured as a part of the project cost. Average cost of the reference book is estimated to be Rs. 600 per copy. Reference books are to be considered as Non-Current Assets and are to be charged @20% on SLM basis. 50% of the Books would be replaced on write off with an additional cost of 10% on account of inflation. G. Human Resources The courses would require two faculty members who will be paid a honorarium of Rs. 3000 on a clock hour basis. Each course would require 60 hours of involvement by the faculty members. Administrative staff (Two) would be paid a total of 50000 per month. H. Other Indirect Costs The business entity budgets a sum of Rs. 25,000 p.m. on account of all other indirect expenses Other costs: Depreciation is to be charged on SLM basis @15%. An income tax rate of 25% can be considered. You may also make additional assumptions wherever required. Inflation is expected to hover around 7% for the next 6 years. This has to be factored in reference to the expenses. You are required to prepare Projected Financial Statements and Evaluate the Project based on a Cost of Capital of 15% and determine the IRR. Assume that at the end of six year period, 20% of the initial cost of the project, subject to a tax rate of 15% would be received as cash inflow. I. A new Company in Training domain projects an initial enrolment of 140 participants in the first year, with an average fees of Rs. 18,000 p.a., per participant. It expects a 10% of Gross Fees revenue by way of other income every year. It expects the enrolment to increase by 10% every year, while the average fees are expected to align with the GDP Growth. GDP is expected to grow @6% on a year on year basis for the next 10 years. Its other project related parameters, outlays and expenses are as follows. A. Non Current Assets DESCRIPTION QTY Computers & accessories Fan & Light fitting Tables, Chairs and File racks at office TOTAL ŞI No 1 2 4 4 B. Deposits Training hall that is to be hired on a lease rent of Rs. 10,000 (Rs. In '00000) Sr. No Description 3 4 Price ('00000) Conveyance Expenses Bank Loans Processing Fees Legal Charges 0.32 0.03 RENTAL DEPOSITS C. Pre-Operative Expenses The business entity estimates the pre-operative expenses as below. Nature of Expense Rs. (in '00000s) Salary and Wages, Telephone Expenses 0.30 0.25 0.40 0.40 Amount 1.50 Cost of Equipment ('00000) 1.28 0.10 0.51 1.90 D. Capital Structure The promoters plan to structure the capital on a 2:1 Debt Equity ratio. Long Term Loans can be raised at an interest cost of 12% p.a. Principal amount of the Loan is repayable on a five year period, on a quarterly instalment basis, with a six month holiday period. E. Working Capital Structure The business expects to maintain its current assets / current liabilities as below. Nature Inventory of Study Materials Creditors Proportion / Ratio 0.25 Requirement 1.50 Months F. Study Materials & Reference Books: Study Materials costing Rs. 200 per subject would be distributed. The same is considered as part of the fees. One copy of reference book based on a strength of 200 participants would be procured as a part of the project cost. Average cost of the reference book is estimated to be Rs. 600 per copy. Reference books are to be considered as Non-Current Assets and are to be charged @20% on SLM basis. 50% of the Books would be replaced on write off with an additional cost of 10% on account of inflation. G. Human Resources The courses would require two faculty members who will be paid a honorarium of Rs. 3000 on a clock hour basis. Each course would require 60 hours of involvement by the faculty members. Administrative staff (Two) would be paid a total of 50000 per month. H. Other Indirect Costs The business entity budgets a sum of Rs. 25,000 p.m. on account of all other indirect expenses Other costs: Depreciation is to be charged on SLM basis @15%. An income tax rate of 25% can be considered. You may also make additional assumptions wherever required. Inflation is expected to hover around 7% for the next 6 years. This has to be factored in reference to the expenses. You are required to prepare Projected Financial Statements and Evaluate the Project based on a Cost of Capital of 15% and determine the IRR. Assume that at the end of six year period, 20% of the initial cost of the project, subject to a tax rate of 15% would be received as cash inflow. I.
Expert Answer:
Answer rating: 100% (QA)
SOLUTION Heres the projected financial statements for the first six years based on the given assumptions Year 1 Revenue 140 participants x Rs 18000 per participant x 12 months Rs 21600000 Gross Profit ... View the full answer
Related Book For
Real Estate Finance and Investments
ISBN: 978-0073377339
14th edition
Authors: William Brueggeman, Jeffrey Fisher
Posted Date:
Students also viewed these finance questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
A machine was sold in December 20x3 for $13,000. It was purchased in January 20x1 for $19,000, and depreciation of $16,000 was recorded from the date of purchase through the date of disposal....
-
The adjusted trial balance of Propp Products at November 30, 2014, is shown on below. Propp Products uses the perpetual inventory system. Required 1. Journalize Propp Products' closing entries. 2....
-
The Federal Deposit Insurance Corporation (FDIC) brings this action to collect on promissory notes signed by certain former partners of the law firm of Finley, Kumble, Wagner, Heine, Underberg,...
-
True or False: Multiple roots can exist when using IRR and MIRR methods.
-
Stine Company uses a job order cost system. On May 1, the company has a balance in Work in Process Inventory of $3,500 and two jobs in process: Job No. 429 $2,000, and Job No. 430 $1,500. During May,...
-
6. MAC =9 The use of energy is one of the major causes of pollution and greenhouse gases that lead to climate change. It is desirable to reduce the emissions from energy use. Suppose there are two...
-
For Youth Agency (FYA) is a voluntary health and welfare organization that provides counseling and recreation programs for youthful offenders and delinquents. FYAs programs are financed through a...
-
How a company's success in generating net income and how net income is used to reward?
-
Write an essay on why performance enhancing drugs should not be used in sports.
-
This assessment is based on a case study. Students must compose a report focused on an organisation that is given the case. The student will evaluate a business identified in the case study, and...
-
If the applicant wanted to find out what his/her references said about him during the reference check, what could he do?
-
Explain how a couture design business's can identify whether a cybersquatting is using their chosen domain name in bad faith?
-
A) Using an appropriate definition for sustainable development, discuss ONE opportunity and TWO threats to achieving sustainable development in the Caribbean region. B) Using two characteristics of...
-
A group of Caribbean investors have approached you to provide consulting services. They require some further understanding of a potential business venture before they will decide whether or not they...
-
B.) What is the approximate concentration of free Zn 2+ ion at equilibrium when 1.0010 -2 mol zinc nitrate is added to 1.00 L of a solution that is 1.080 M in OH - . For [Zn(OH) 4 ] 2- , K f = 4.610...
-
As a financial advisor for the Spain Development Co., you have been given the construction and marketing studies for the proposed Timbercreek office project. Several potential sites have been...
-
A partially amortizing loan for $90,000 for 10 years is made at 6 percent interest. The lender and borrower agree that payments will be monthly and that a balance of $20,000 will remain and be repaid...
-
Why is the value of corporate real estate often considered hidden from shareholders?
-
An analyst makes the following statement: Use of P/E and other multiples for analysis is not effective because the multiples are based on historical data and because not all companies have positive...
-
The primary difference between P/E multiples based on comparables and P/E multiples based on fundamentals is that fundamentals-based P/Es take into account: A. Future expectations. B. The law of one...
-
A price-to-earnings ratio that is derived from the Gordon growth model is inversely related to the: A. Growth rate. B. Dividend payout ratio. C. Required rate of return.
Study smarter with the SolutionInn App