Question: Excel Spread sheets, will someone be able to help me with this? Health & Fitness Gym Date Prepared: Client Andrews Baker Carter Dudley Evans Foust

 Excel Spread sheets, will someone be able to help me with

Excel Spread sheets, will someone be able to help me with this?

this? Health & Fitness Gym Date Prepared: Client Andrews Baker Carter Dudley

Health & Fitness Gym Date Prepared: Client Andrews Baker Carter Dudley Evans Foust Gardner Hart Ivans Totals Membership Deluxe Family Individual Membership Deluxe Individual Family Deluxe Deluxe Individual Individual Individual Individual Cost $ $ $ Locker Fee $ Interest Rate Months Per Year Cost Locker Annual Total Years Yes 1 Yes 2 No 3 No 2 Yes 3 No 1 No 2 No 3 Yes 3 Down Payment 575 $ 250 1,500 $ 700 300 $ 150 75 5.75% 12 Total Due Down Payment BalanceMonthly Payment 0 Err:522 Err:522 Err:522 Err:522 Err:522 Err:522 Err:522 Err:522 Summary Statistics Number of New Members Lowest Monthly Payment Average Monthly Payment Maxium Monthly Payment Median Monthly Payment Townsend Mortgage Company Input Area Today's Date: Pmts Per Year: 12 Loan # Down Amount House Cost Payment Financed 452786 453000 453025 452600 452638 $ $ $ $ $ 400,000 350,000 175,500 265,950 329,750 $ $ $ $ $ 80,000 60,000 30,000 58,000 65,000 Summary Statistics Statistics Total Average Median Lowest Highest # of Mortgages Down Amount House Cost Payment Financed Mortgage Rate 3.625% 3.940% 3.550% 2.500% 3.250% Rate Per Period # of Pmt % Date Payoff Years Periods Financed Financed Year 25 30 25 15 30 5/1/2011 11/3/2011 4/10/2012 10/14/2012 2/4/2013 Townsend Mortgage Company Input Area Today's Date: # Pmts Per Year: PMI Rate: Down Pmt Rate: Years 12/20/2015 12 0.38% 20.0% Loan # $ $ $ $ $ Down Payment House Cost 392786 393000 393025 392600 392638 15 25 30 425,750 335,900 205,500 285,900 329,900 $ $ $ $ $ 86,000 75,500 30,000 50,000 70,000 Rate 3.250% 3.625% 3.750% Amount Financed % Down $ $ $ $ $ 339,750 260,400 175,500 235,900 259,900 20.2% 22.5% 14.6% 17.5% 21.2% Years 25 30 25 15 30 APR Monthly Payment Monthly PMI Computer-Related Jobs # of Jobs Systems Analysts Software App Developers Programmers Network/System Admins CIS Managers Info Security Analysts Database Administrators Job Growth 2010 2020 Est. 544,400 664,800 520,800 664,500 363,100 406,800 347,200 443,800 307,900 363,700 302,300 367,900 110,800 144,800 # of New Jobs % Growth 120,400 22% 143,700 28% 43,700 12% 96,600 28% 55,800 18% 65,600 22% 34,000 31% Median Pay $ $ $ $ $ $ $ 2010 77,740 90,530 71,380 69,160 115,780 75,660 73,490 Source: Bureau of Labor Statistics, U.S. Department of Labor, Occupational Outlook Handbook, 2012-13 Edition, on the Internet at http://www.bls.gov/

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!