Amortization and Income Statements
Not what you're looking for?
1. To buy a new house you take out a 25 year mortgage for $300,000. What will your monthly interest rate payments be if the interest rate on your mortgage is 8 percent?
rate (i) =
number of periods (n)=
present value (PV) =$300,000
future value (FV) =$0
type (0 = at end of period) =0
monthly mortgage payment=
2. Prepare a Pro Forma Income Statement
Net Sales =$2,938 COGS=$1,598 SG&A=$475 Depreciation=45 Interest Exp=$32 Tax=15%
Show in Excel the following:
Net Sales
Cost Of Goods Sold
Gross Profit
Selling & Admin Exp
Depreciation
Interest Exp
Income Before Taxes
Income Taxes
Net Profit
Purchase this Solution
Solution Summary
This response calculates the monthly interest rate payments of a mortgage and provides instructions on how to prepare a pro forma income statement.
Solution Preview
1.
rate (i) = 8%
number of periods (n) = 25
present value (PV) = $300,000
future value (FV) = $0
type (0 = at ...
Education
- MBA, Indian Institute of Finance
- Bsc, Madras University
Recent Feedback
- "I've posted a similar question for another course. It's post 657940, and it's a practice problem that I'd like to use for the final exam. Your help will be greatly appreciated. "
- "thank you!"
- "Thank you again Jayant. You are super fast. "
- "Thank you Jayant. You are appreciated. "
- "Again, thank you Jayant. You are wonderful. "
Purchase this Solution
Free BrainMass Quizzes
Operations Management
This quiz tests a student's knowledge about Operations Management
Marketing Management Philosophies Quiz
A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.
MS Word 2010-Tricky Features
These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.
Basic Social Media Concepts
The quiz will test your knowledge on basic social media concepts.
Organizational Behavior (OB)
The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.