Prepare Projected Financial Statements

Assignment Help Financial Accounting
Reference no: EM132874464

Question - A Start-up 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 Price ('00000) Cost of Equipment ('00000)

Computers & accessories 4 0.32 1.28

Fan & Light fitting 4 0.03 0.10

Tables, Chairs and File racks at office 0.51

TOTAL 1.90

B. Deposits

Training hall that is to be hired on a lease rent of Rs. 10,000 (Rs. In '00000)

Sr. No Description Amount

RENTAL DEPOSITS 1.50

C. Pre-Operative Expenses

The business entity estimates the pre-operative expenses as below.

S No Nature of Expense Rs. (in '00000s)

1 Salary and Wages, Telephone Expenses 0.30

2 Conveyance Expenses 0.25

3 Bank Loans Processing Fees 0.40

4 Legal Charges 0.40

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 Proportion / Ratio

Inventory of Study Materials 0.25 Requirement

Creditors 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

I. 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.

Reference no: EM132874464

Questions Cloud

Understanding of role of leaders and managers : Do the arguments in the article challenge or support your understanding of the role of leaders and managers in an organization?
Developed the project schedule : Now that you have developed the project schedule and are working on your cost estimate,
How would go about getting buy-in for proposed policy : How would go about getting buy-in for proposed policy? What stakeholder groups need to be involved in promoting your policy?
Analyzing and visualizing data : Respond with an example of your choice that illustrates the 3Es of visualization (effective, ethical, and efficient) as outlined in the materials. Include the g
Prepare Projected Financial Statements : You are required to prepare Projected Financial Statements and Evaluate the Project based on a Cost of Capital of 15% and determine the IRR
Write a short note on changing role of hrm : Write a short note on "changing role of HRM" and "Women leadership and inclusion along with latest trends and examples.
Benefits of implementing supply chain management on floor : Develop a compelling presentation to the operations manager that will explore the benefits of implementing supply chain management on his floor.
Conceptualisation of the role of hr professionals : For HR Practitioners, the role of pursuing a strategic focus on their organisation's business strategy, is incompatible with the role of championing employee we
Brief summary of american airliness operations : Brief summary of American airlines's operations - Which of the three sections of the Statement of Cash Flows (Operating, Investing or Financing Activities)

Reviews

Write a Review

Financial Accounting Questions & Answers

  What would be the value of this bond

A bond that matures in 14 years has a $1,000 par value. What would be the value of this bond if it paid interest semiannually

  What is the contribution margin per unit

The Haskins Company manufactures and sells radios. Each radio sells for $51.25 and the variable cost per unit is $28.75. Haskin's total fixed costs are $52,000.00, and budgeted sales are 28,000.00 units. What is the contribution margin per unit?

  Compute symanteks rate of return on assets for each year

Compute Symantek's rate of return on assets for each year of the project, assuming that accounting expenses R&D expenditures as they occur. Use the year-end balance of total assets in the denominator.

  What is the correct net income for 2014

Pettit Company reports net income of $84,950 in 2014. However, ending inventory was understated $7,640. -  What is the correct net income for 2014?

  Prepare a statement of owner equity for September

Received $1,300 from the club for managing the tennis courts during September. Prepare a statement of owner equity for September

  How much money will the company have in account five year

$50,000 to the account If the account continues to earn 4% interest, how much money will the company have in its account five years from now?

  How can being in debt help build wealth

What is the cost of your debts? What determined those costs? What risksd do you undertake by being in debt? How can being in debt help you build wealth?

  What amount did viva inc trial balance show as total credit

What amount did Viva Inc's trial balance show as its total credits? Viva Inc's trial balance showed the balances below at the end of its first year

  What are basic factors that determine value of a currency

What are the basic factors that determine the value of a currency? In equilibrium, what is the relationship between these factors?

  Show how the bonds would be reported on the balance sheet

Sandhill Corporation issues $390,000 of bonds for $397,800. Show how the bonds would be reported on the balance sheet at the date of issuance.

  What are the tax consequences to terry

when Terry deeds the property to the creditor, she also receives $25,000 from the creditor. What are the tax consequences to Terry?

  Evaluate the annual financing cost

Determining the annual financing cost of borrowing - Evaluate the annual financing cost of borrowing each of the following amounts under the credit agreement

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd