NPV Analysis- Nagud Company
Not what you're looking for?
12. The Nagud Company had the following financial information in the annual audited financial statements.
Balance Sheet
Current Assets Current Liabilities
Cash $ 2,500 Accounts Payable $5,000
Accounts Receivable 5,000 Total Current Liab. 5,000
Inventory 2,500
Total Current Assets 10,000
Fixed Assets 10,000 Long Term Debt (@ 10%) 5,000
Total Liabilities 10,000
Stockholders' Equity 10,000
Total Assets $20,000 Total Liab. and SE $20,000
Income Statement
Sales $ 25,000
Cost of Goods 10,000
Profit Margin (60%) 15,000
Operating Expenses 12,000
Earnings before interest and taxes 3,000
Interest Expense (no taxes this year) 500
Net Income $ 2,500
The following are the assumptions:
Sales growth: year 1-4%, year 2-6%, and year 3-5%
Profit Margin: the ratio will stay the same for all three years
Operating Expenses growth: year 1-5%, year 2-5%, and year 3-5%
Long Term Debt/Interest: Long-term debt will decrease $500 per year
Taxes: No taxes. The company has a large loss carry-forward.
Using the information above, prepare a Net Present Value analysis of the 3-year financial forecast of the Income Statement. The annual discount is assumed to be 6%. I would recommend (not required) setting up an Excel Spreadsheet with supporting work for this problems, noting your answer here and the work in the Excel spreadsheet for my reference. What is the Net Present Value of operations after 3 years?
Please see attached file for complete details.
Purchase this Solution
Solution Summary
The solution prepares a Net Present Value analysis of the 3-year financial forecast of the Income Statement.
Solution Preview
See attached file for complete details.
12. The Nagud Company had the following financial information in the annual audited financial statements
Balance Sheet
Current Assets Current Liabilities
Cash $ 2,500 Accounts Payable $5,000
Accounts Receivable 5,000 Total Current Liab. 5,000
Inventory 2,500
Total Current Assets 10,000 Long Term Debt (@ 10%) 5,000
Total Liabilities 10,000
Fixed Assets 10,000 Long Term Debt (@ 10%) 5,000
Total Liabilities 10,000
...
Purchase this Solution
Free BrainMass Quizzes
Marketing Research and Forecasting
The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.
Team Development Strategies
This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.
Learning Lean
This quiz will help you understand the basic concepts of Lean.
Six Sigma for Process Improvement
A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.
Social Media: Pinterest
This quiz introduces basic concepts of Pinterest social media