Purchase Solution

How Much Are You Worth - Student Equity Research

Not what you're looking for?

Ask Custom Question

See attached files.

Clarification: Sample spreadsheet with 3 tabs is attached. Typical income, assets, and expenses for a Grad school student or graduate are to be used to complete this spreadsheet. The highlighted figures in yellow are examples.

I am requesting assistance in completing the spreadsheets. I will summarize the findings and prepare a report.

Purchase this Solution

Solution Summary

How Much Are You Worth - Student Equity Research

Solution Preview

I begin by listing all the assumptions,

-The balance sheet and income statement contain made up financial data

-I choose 4% of long term revenue growth rate and 2% for long term earning growth rate. Why these numbers? In Canada (which is where I am), generally employers give a 3-4% raise every year. Since the main income is salary (we assume that the graduate student does not operate a business), his revenue growth is roughly 4%. The average inflation rate in Canada is 2% (slightly higher in US, about 3%), so the expenses will grow at around 2%/year. This means his earning is growing at about 2%/year (= 4% income growth - 2% expenses growth).

-Historically, 10 Yr bond yield is around 5%/year, so we use this as the ...

Purchase this Solution


Free BrainMass Quizzes
Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

Learning Lean

This quiz will help you understand the basic concepts of Lean.

Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.

Introduction to Finance

This quiz test introductory finance topics.

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.