Purchase Solution

Amortization and Income Statements

Not what you're looking for?

Ask Custom Question

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

Solution provided by:
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.