Make a pro forma income statement

Reference no: EM1356584

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

Reference no: EM1356584

Questions Cloud

Amortization for a patent : A corporation buy a patent for $900K with an estimated life of 15 years. It is subsequently reduced to ten years. During year 5, the product for which the patent is held is removed from market.

Write a program to find solution tocryparithmetic puzzle : Write a program (Crypta.java) that finds a solution to the cryparithmetic puzzle: TOO + TOO + TOO+ TOO = GOOD

Show communication between leaders and followers : Explain what might be any conceivably different impacts, considerations, or challenges leaders then faced in the mid-1940s vs. our current time regarding innovation, change, and teaming?

Interview model for family therapy or counseling : What are the specific steps in the Interview Model for Family Therapy/Counseling, e.g. the Systemic Contextual Approach?

Make a pro forma income statement : To purchase a new home 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%

Does a group always need a leader to function well : Does a group ALWAYS need a leader to function well and is there a single, true leader in this group

Configuring dhcp with alternate ip address configuration : By configuring DHCP with an Alternate IP Address Configuration. Describe how this technique could be used in an IT environment of your choosing.

Concepts of personality and psychopathology : How would Rogerian concepts of personality and psychopathology apply to his situation?

Bias in politics : What can done to improve our capacity to choose good people for the job and comfort us that we have done so adequately and fairly.

User Account

All Pages