Management Information Systems Term Paper

Download this Term Paper in word format (.doc)

Note: Sample below may appear distorted but all corresponding word document files contain proper formatting

Excerpt from Term Paper:

Management Information Systems

Worksheet with Formulas

Agreed purchase price of the house (£)

Annual cost of living increase (£)

Annual buildings insurance premium (£)

Annual house maintenance expense (£)

Annual house appreciation rate (%)

Bank deposit interest rate (%)

Bank loan interest rate (%)

Cost of petrol per litre (£)

Council Tax Band A, lowest value (£)

Council Tax Band B, lowest value (£)

Council Tax Band C, lowest value (£)

Days worked per year (days)

Deposit percentage (%)

Distance of house from work (km)

Expected value of renovated house (£)

Initial renovation expenses (£)

Mortgage interest rate (%)

Mortgage percentage (%)

Mortgage repayment period (years)

Personal loan repayment period (months)

Petrol consumption (km/litre)

Savings (£)

Solicitor's fees (£)

Stamp duty limit (£)

Stamp duty rate (%)

VAT rate (%)

INITIAL COSTS

Deposit

PurchasePrice*10%

Solicitor's Fees (including VAT)

SolicitorFee+(SolicitorFee*17.5%)

Stamp Duty Applicable

IF (PurchasePrice>StampDutyLimit, PurchasePrice*StampDutyRate,0)

Total initial costs

Deposit+SolicitorFeeIncVAT+StampDutyApplicable

Amount of personal loan required

Amount placed in bank

CONTINUING COSTS

Year 1

Council tax

VLOOKUP (PurchasePrice,$B$11:$C$13,2)

Insurance premiums

AnnualInsurancePremium

House maintenance

AnnualHouseMaintenance

Travel to and from work

DistanceOfHouseFromWork*2)/PetrolConsumption)*CostOfPetrolPerLiter)*

DaysWorkedPerYear

Initial renovation

InitialRenovationExpense

Mortgage repayments

1)*PMT (MortIntRate, MortRepayPeriod, MortPerc*PurchasePrice)

Personal loan repayments

Less bank account interest

AmtPlacedInBank*BankDepIntRate)*(-1)

Total continuing costs

CouncilTax+InsurancePremium+HouseMaintenance+Travel_to_and_from_work+

InitialRenovation+MortgageRepayments+PersonalLoanRepayments+

LessBankAccountInterest

CAPITAL COSTS

Interest on savings lost

Savings*BankDepIntRate)+LessBankAccountInterest

END OF YEAR SUMMARY

Total costs during year

TotalContinuingCost+InterestOnSavingsLost

Total monthly cost during year

TotalCostsDuringYear/12

Total costs to date at end of year

TotalCostsDuringYear

Value of house at end of year

PurchasePrice+(PurchasePrice*AnnualHouseAppreciationRate)

HOUSE A VARIABLE SECTION

Variable

Agreed purchase price of the house (£)

Annual cost of living increase (£)

Annual buildings insurance premium (£)

Annual house maintenance expense (£)

Annual house appreciation rate (%)

Bank deposit interest rate (%)

Bank loan interest rate (%)

Cost of petrol per litre (£)

Council Tax Band A, lowest value (£)

Council Tax Band B, lowest value (£)

Council Tax Band C, lowest value (£)

Days worked per year (days)

Deposit percentage (%)

Distance of house from work (km)

Expected value of renovated house (£)

Initial renovation expenses (£)

Mortgage interest rate (%)

Mortgage percentage (%)

Mortgage repayment period (years)

Personal loan repayment period (months)

Petrol consumption (km/litre)

Savings (£)

Solicitor's fees (£)

Stamp duty limit (£)

Stamp duty rate (%)

VAT rate (%)

INITIAL COSTS

Deposit

Solicitor's Fees (including VAT)

Stamp Duty Applicable

Total initial costs

Amount of personal loan required

Amount placed in bank

CONTINUING COSTS

Year 1

Year 2

Year 3

Year 4

Year 5

Council tax

Insurance premiums

House maintenance

Continuation of House A Travel to and from work

Initial renovation

Mortgage repayments

Personal loan repayments

Less bank account interest

Total continuing costs

CAPITAL COSTS

Interest on savings lost

END OF YEAR SUMMARY

Total costs during year

Total monthly cost during year

Total costs to date at end of year

Value of house at end of year

HOUSE B

VARIABLE SECTION

Variable

Agreed purchase price of the house (£)

Annual cost of living increase (£)

Annual buildings insurance premium (£)

Annual house maintenance expense (£)

Annual house appreciation rate (%)

Bank deposit interest rate (%)

Bank loan interest rate (%)

Cost of petrol per litre (£)

Council Tax Band A, lowest value (£)

Council Tax Band B, lowest value (£)

Council Tax Band C, lowest value (£)

Days worked per year (days)

Deposit percentage (%)

Distance of house from work (km)

Expected value of renovated house (£)

Initial renovation expenses (£)

Mortgage interest rate (%)

Mortgage percentage (%)

Mortgage repayment period (years)

Personal loan repayment period (months)

Continuation of House B

Petrol consumption (km/litre)

Savings (£)

Solicitor's fees (£)

Stamp duty limit (£)

Stamp duty rate (%)

VAT rate (%)

INITIAL COSTS

Deposit

Solicitor's Fees (including VAT)

Stamp Duty Applicable

Total initial costs

Amount of personal loan required

Amount placed in bank

CONTINUING COSTS

Year 1

Year 2

Year 3

Year 4

Year 5

Council tax

Insurance premiums

House maintenance

Travel to and from work

Initial renovation

Mortgage repayments

Personal loan repayments

Less bank account interest

Total continuing costs

CAPITAL COSTS

Interest on savings lost

END OF YEAR SUMMARY

Total costs during year

Total monthly cost during year

Total costs to date at end of year

Value of house at end of year

HOUSE C

VARIABLE SECTION

Variable

Agreed purchase price of the house (£)

Continuation of House C

Annual cost of living increase (£)

Annual buildings insurance premium (£)

Annual house maintenance expense (£)

Annual house appreciation rate (%)

Bank deposit interest rate (%)

Bank loan interest rate (%)

Cost of petrol per litre (£)

Council Tax Band A, lowest value (£)

Council Tax Band B, lowest value (£)

Council Tax Band C, lowest value (£)

Days worked per year (days)

Deposit percentage (%)

Distance of house from work (km)

Expected value of renovated house (£)

Initial renovation expenses (£)

Mortgage interest rate (%)

Mortgage percentage (%)

Mortgage repayment period (years)

Personal loan repayment period (months)

Petrol consumption (km/litre)

Savings (£)

Solicitor's fees (£)

Stamp duty limit (£)

Stamp duty rate (%)

VAT rate (%)

INITIAL COSTS

Deposit

Solicitor's Fees (including VAT)

Stamp Duty Applicable

Total initial costs

Amount of personal loan required

Amount placed in bank

CONTINUING COSTS

Year 1

Year 2

Year 3

Year 4

Year 5

Council tax

Insurance premiums

House maintenance

Travel to and from work

Initial renovation

Continuation of House C

Mortgage repayments

Personal loan repayments

Less bank account interest

Total continuing costs

CAPITAL COSTS

Interest on savings lost

END OF YEAR SUMMARY

Total costs during year

Total monthly cost during year

Total costs to date at end of year

Value of house at end of year

HOUSE D

VARIABLE SECTION

Variable

Agreed purchase price of the house (£)

Annual cost of living increase (£)

Annual buildings insurance premium (£)

Annual house maintenance expense (£)

Annual house appreciation rate (%)

Bank deposit interest rate (%)

Bank loan interest rate (%)

Cost of petrol per litre (£)

Council Tax Band A, lowest value (£)

Council Tax Band B, lowest value (£)

Council Tax Band C, lowest value (£)

Days worked per year (days)

Deposit percentage (%)

Distance of house from work (km)

Expected value of renovated house (£)

Initial renovation expenses (£)

Mortgage interest rate (%)

Mortgage percentage (%)

Mortgage repayment period (years)

Continuation of House D

Personal loan repayment period (months)

Petrol consumption (km/litre)

Savings (£)

Solicitor's fees (£)

Stamp duty limit (£)

Stamp duty rate (%)

VAT rate (%)

INITIAL COSTS

Deposit

Solicitor's Fees (including VAT)

Stamp Duty Applicable

Total initial costs

Amount of personal loan required

Amount placed in bank

CONTINUING COSTS

Year 1

Year 2

Year 3

Year 4

Year 5

Council tax

Insurance premiums

House maintenance

Travel to and from work

Initial renovation

Mortgage repayments

Personal loan repayments

Less bank account interest

Total continuing costs

CAPITAL COSTS

Interest on savings lost

END OF YEAR SUMMARY

Total costs during year

Total monthly cost during year

Total costs to date at end of year

Value of house at end of year

Ways in which Scenario Manager and other Excel features can aid in the process of decision making.

The Scenario Manager used in the house-buying examples is a method that can facilitate a buyer's process of decision-making. Through the tabular form of expected expenses and expected value of the houses, a buyer can easily see the differences between each house, as well as whether the values match the buyer's financial capabilities.

The Excel features also serve as useful tools that facilitate computations. Such features become handy especially when certain values need to be changed. Through the Excel's capability of storing formulas, automatic computation is made possible. This feature eliminates the need for redundant computations should a value in the variable area of our examples' Scenario Manager is changed.

Aside from the ability to facilitate computations, the Scenario Manager and the Excel features eliminates the time-consuming process of waiting for the essential computational results before a decision can be made. As in our examples, the Scenario Manager and the Excel features can aid a buyer in his decision-making process through a presented organized view of the necessary factors, particularly the expected amount of expenses and liabilities when buying a house, before coming up with a decision.

Every process of decision-making entails the need for a detailed and clear presentation of information to allow a decision-maker see the advantages and disadvantages between available options. This necessity is the fundamental feature that our examples' Scenario Manager provides. Through the organized structure of a house's details and computations, a buyer can easily pre-decide in just a brief study of the information provided by the Scenario Manager.

Implications and Relative Advantages and Disadvantages of Buying Each House

Each house presented has relative advantages and disadvantages to a buyer. Following is a discussion of these factors based on each house and based on comparison of each with the other houses.

Buying house A, being the least expensive of the four houses in terms of purchase price, offers the most financial convenience to a buyer in terms of initial costs. Compared to the other three houses, house A requires…[continue]

Cite This Term Paper:

"Management Information Systems" (2004, January 21) Retrieved December 8, 2016, from http://www.paperdue.com/essay/management-information-systems-161383

"Management Information Systems" 21 January 2004. Web.8 December. 2016. <http://www.paperdue.com/essay/management-information-systems-161383>

"Management Information Systems", 21 January 2004, Accessed.8 December. 2016, http://www.paperdue.com/essay/management-information-systems-161383

Other Documents Pertaining To This Topic

  • Management Information Systems

    Management Information Systems Internet business-to-business sales will attain approximately $1.3 trillion in 2003 and, in 2004, business-to-consumer sales will attain approximately $100 billion. E-businesses at the moment have attained a point where they are trying to move away from a superficial analysis of their customers to engaging in rich customer relations. Strategic customer relationship management and its relationship to e-business is the focus of this paper. Internet business-to-business sales will attain approximately

  • Managing Information Systems Introduction in

    Furuholt, (2006) argues that lack of management engagement to the acceptance of information systems has been a barrier to the implementation of information systems. The issues are even common with organizations in the developing countries where management does not give enough priority to the information systems implementation. Importantly, implementation of information systems requires management support since management will need to approve fund that would be used for IS implementation.

  • Management Information System Is Described

    Like, in the case of public sector training project which aim at providing new skills for the unemployed, (Richard Heeks, 1998). Such project turns inputs of staff labor, equipment and money to a level of outputs skilled individuals who have undergone training through process of training delivery. B) a monitoring mechanism: The mechanism tends to collect information concerning the outputs from the process. In this case, the information to

  • Management Information Systems What Are

    Unit Three writing assignment: How are partner relationship management (PRM) and employee relationship management (ERM) related to customer relationship management (CRM)? As the primary objective of CRM is to provide businesses with a 360 degree view of their customers, Partner Relationship Management (PRM) is used for providing companies a 360 degree view of their distribution channel partners. Employee Relationship Management (ERM) systems also use the same foundation of CRM, yet the

  • Management Information Systems MIS Organization

    The information security system also helps in the provision of guidelines in the analysis and in the evaluation of security systems which are considered vulnerable to be used based on the former or initially used security measures in the organization system e.g. The use of anti-viruses, firewalls, intrusion detectives etc. Role of ethics when building customer database Ethics refers to the that branch of philosophy dealing with values relating to human conduct,

  • Management Information Systems How Social

    This is also in the context of bringing more relevant information to customers across all of these social media channels, and always living by the axiom of getting what you give (Bernoff, Schadler, 2010). Social media channels need to be orchestrated as any other multichannel strategy, with the leading companies globally today realizing that each of their customer bases relies on different social media channels for different needs (Bernoff, Schadler,

  • Information Systems Management Information Systems

    Cloud computing is a trend in technology providing cost control and real agility business benefits. Nevertheless, services based on cloud computing are currently floating outside privacy and security standards, which is likely to be decades old thus failing to address concerns such as shared tenancy and virtualization (Gibson, 2011). Similarly, cloud computing comes with more challenges; providers of cloud services are likely to outsource third party experts and if such


Read Full Term Paper
Copyright 2016 . All Rights Reserved