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)
To solve the problem and prepare the projected financial statements lets follow the steps outlined e... 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
-
As humans, we constantly perceive things: sounds, sights, smells and movement. Some of these perceptions are accurate while some others are erroneous. A frequent perception mistake occurs at night...
-
3. The U.S. auto industry produces approximately 6 million vehicles a year, each containing roughly 1.5 metric tons of fabricated metal. Consider a future wind-turbine industry having half of the...
-
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....
-
A fair coin is tossed four times, and the random variable X is the number of heads in the first three tosses and the random variable Y is the number of heads in the last three tosses. (a) What is the...
-
The following table lists the components needed to assemble an end item, the manufacturing or purchase lead times (in weeks) for typical lot sizes, amount on hand, and the direct components of each...
-
Which data entry application control would detect and prevent entry of alpha betic characters as the price of an item in the inventory master file? a. field check c. completeness check b. limit check...
-
Suppose there are 10 individuals with values as follows: {10, 8, 8, 8, 8, 8, 8, 4, 0, 0}. Construct a demand schedule (table), and calculate the marginal revenue of the second unit sold.
-
! Required information [The following information applies to the questions displayed below.] Astro Company sold 28,500 units of its only product and reported income of $57,900 for the current year....
-
Let today be November 3, 2008. (a) Use the LIBOR rate and the swap data on November 3, 2008 in Table 11.26 and fit the LIBOR curve. (b) From the LIBOR discount curve, fit the Ho-Lee model of the...
-
Write a Python function to: (1) Calculate the 2nd moment of area (2) Determine the Maximum Bending Stress (3) Draw bending moment distribution diagram
-
Design a program to combat a type of violence of your choice that will include elements of both primary and secondary prevention. What factors of your program are directed toward primary prevention,...
-
A company is considering the purchase of a new piece of equipment for $91.000. It is expected to produce the following net cash flows. The payback period is: Year 1 Year 2 Year 3 Year 4 Year 5 Net...
-
Write a resume with the free tool below and post it to the discussion panel.
-
Find the vector equation for the line of intersection of the planes 3x + 3y + 4z = 5 and 3x + z = -5
-
1) What you accomplished/learned there. (2) What you feel you learned about yourself as a marketing professional. (3) What you felt were your assets to the company. (4) What you feel you'll need to...
-
Rhonda has her own law practice in London, Ontario. During 2020 she paid $1000 to attend four conventions. Each convention cost a quarter of the total spent. All four conventions were hosted in...
-
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?
-
Classify each of the following costs relative to the cost object customer for a new car dealer: Salesperson wages Dealership manager salary. Depreciation on showroom furniture. Cost of automobiles...
-
Complete the following T-accounts: Materials Inventory ? 20,000 19,900 300 Wages Payable 15,000 Work-in-Process Inventory Finished Goods Inventory 2,000 ? 5,000 ? ? ? ? ? 3,000 32,000 5,000...
-
Benton Engineering Services Company incurred the following during 2019: Calculate prime cost and conversion cost for Benton Engineering Services Company during 2019. Direct labor.. Overhead Selling...
Study smarter with the SolutionInn App