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

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

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