project

profile3limalallah
CH9AliM.x.xlsx
Home>Business & Finance homework help>Accounting homework help>project

Income Statements

Income Statement Year 1 Year 2 Year 3 Year 4 Year 5
Income Statements in U.S. Dollars as of December 31st
Revenue
Salary/Wages $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Gross Income $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Expenses
Payroll Taxes
SSA @ 6.2% $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Medicare @ 1.4% $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Transportation:
Public/Uber/Other (Monthly) $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Car Purchase: Payment $ - 0 $ - 0 $ - 0 $ - 0
Insurance (Monthly) $ - 0 $ - 0 $ - 0 $ - 0
Maintenance/Gas/Repairs $ - 0 $ - 0 $ - 0 $ - 0
401K Savings $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Medical Insurance $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Furnishings 1 Payment $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Furnishings 2 Payment $ - 0 $ - 0 $ - 0
Rent/Mortgage Payment $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Renters'/Homeowner's Insurance $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Property Tax $ - 0 $ - 0 $ - 0
Food/Household Supplies (Monthly) $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Telephone/Wifi/Cable $ 150 $ 1,800 $ 1,836 $ 1,873 $ 1,910 $ 1,948
Travel/Entertainment $ - 0
Utilities $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Down Payment/Principal Payments $ - 0 $ - 0 $ - 0 $ - 0
Federal Income Tax `
Gross Income $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Standard Deduction $ 6,350 $ 6,477 $ 6,607 $ 6,739 $ 6,873
Mortgage Int. Ded. $ - 0 $ - 0 $ - 0
Prop. Tax Deduction $ - 0 $ - 0 $ - 0
401 K Savings Deduction $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Adjusted Gross Income $ (6,350) $ (6,477) $ (6,607) $ (6,739) $ (6,873)
Net Tax $ (5,849) $ (5,849) $ (5,998) $ (5,998) $ (6,031) $ (6,031) $ (6,065) $ (6,065) $ (6,099) $ (6,099)
Total Expenses $ (4,049) $ (4,162) $ (4,158) $ (4,155) $ (4,151)
Net Income $ 4,049 $ 4,162 $ 4,158 $ 4,155 $ 4,151
Other Income
Employer 401K Match $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Other Income $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Net Income (Loss) $ 4,049 $ 4,162 $ 4,158 $ 4,155 $ 4,151

Decisions

Decision Entry - All decisions are effective January 1st of the current year
YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5
Period = Monthly Annual Monthly Annual Monthly Annual Monthly Annual Monthly Annual
Annual Salary Annual Salary 0 Annual Salary 0 Annual Salary 0 Annual Salary 0
Apartment Rental Apartment Rental
Sq. Ft. Sq. Ft. 0
Rent @1.25/sf 0 0 Rent 0 0
Insurance 0 0 Insurance 0 0
Utilities 0 0 Utilities 0 0
Furniture Purchase 1 Furniture Purchase 1 Furniture Purchase 1 Furniture Purchase 1 Furniture Purchase 1
Price Balance 0 Balance 0 Balance 0 Balance 0
Sales Tax 0
Down Pmnt Down Pmnt Down Pmnt Down Pmnt
IR 10% IR 10% IR 10% IR 10% IR 10%
Years 5 Years 5 Years 5 Years 5 Years 5
PMT 0 PMT 0 PMT 0 PMT 0 PMT 0 0
Year 1 Principal Balance Year 2 Principal Balance Year 3 Principal Balance Year 4 Principal Balance Year 5 Principal Balance
Pd 0 Pd 0 Pd 0 Pd 0 Pd 0
Bal 0 Bal 0 Bal 0 Bal 0 Bal 0
Auto Purchase Auto Purchase Auto Purchase Auto Purchase
Price Balance 0 Balance 0 Balance 0
Tax, Title, Reg. 0
Down Pmnt Down Pmnt Down Pmnt Down Pmnt
IR 6.5% IR 6.5% IR 6.5% IR 6.5%
Years 5 Years 5 Years 5 Years 5
PMT 0 PMT 0 PMT 0 PMT 0
Year 1 Principal Balance Year 2 Principal Balance Year 3 Principal Balance Year 4 Principal Balance
Pd 0 Pd 0 Pd 0 Pd 0
Bal 0 Bal 0 Bal 0 Bal 0
Home Purchase Home Purchase Home Purchase
Price Balance 0 Balance 0
Sq. Ft.
Down Payment @ 3% 0
Closing Costs @ 1.5% 0 Down Pmnt Down Pmnt
PMT (30 [email protected]%) 0 0 PMT 0 0 PMT 0 0
Year 1 Interest Paid 0 Year 2 Interest Paid 0 Year 3 Interest Paid 0
Year 1 Principal Balance Year 2 Principal Balance Year 3 Principal Balance
Pd 0 Pd 0 Pd 0
Bal 0 Bal 0 Bal 0
Furniture Purchase 2 Furniture Purchase 2 Furniture Purchase 2
Price Balance 0 Balance 0
Sales Tax 0
Down Pmnt Down Pmnt
IR 10% IR 10% IR 10%
` Years 5 Years 5 Years 5
PMT 0 PMT 0 PMT 0
Year 1 Principal Balance Year 2 Principal Balance Year 3 Principal Balance
Pd 0 Pd 0 Pd 0
Bal 0 Bal 0 Bal 0

Balance Sheet

Balance Sheets
Balance Sheets as of December 31st Year 1 Year 2 Year 3 Year 4 Year 5
Current Assets
Cash Balance $ 4,049 $ 8,211 $ 12,369 $ 16,524 $ 20,675
401K Balance $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total $ 4,049 $ 8,211 $ 12,369 $ 16,524 $ 20,675
Fixed Assets
Home $ - 0 $ - 0 $ - 0
Car $ - 0 $ - 0 $ - 0 $ - 0
Furniture $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Less accumulated depreciation (Negative Value) $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Assets $ 4,049 $ 8,211 $ 12,369 $ 16,524 $ 20,675
Current Liabilities (Next 12 Months)
Current Portion of Long Term Debt $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Other
Total Current Liabilities $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Long-term Liabilities
Mortgage payable $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Auto $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Furniture $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Long-term Liabilities $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Liabilities $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Owner's Net Worth $ 4,049 $ 8,211 $ 12,369 $ 16,524 $ 20,675

Variables

_Example FALSE
_Shading FALSE
_Series OfficeReady 3.0
_Look 1