Purchase Solution

# 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
Depreciation
Interest Exp
Income Before Taxes
Income Taxes
Net Profit

##### 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
###### Recent Feedback
• "thank you!"
• "Thank you again Jayant. You are super fast. "
• "Thank you Jayant. You are appreciated. "
• "Again, thank you Jayant. You are wonderful. "
• "Thanks Jayant."

##### Introduction to Finance

This quiz test introductory finance topics.

##### Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

##### Operations Management

This quiz tests a student's knowledge about Operations Management

##### Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

##### Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.