Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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

image text in transcribed 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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Accounting Reporting and Analysis

Authors: James M. Wahlen, Jefferson P. Jones, Donald Pagach

3rd edition

9781337909402, 978-1337788281

More Books

Students also viewed these Accounting questions

Question

Identify the six steps to the personal risk management process.

Answered: 1 week ago