Preview

Cmis102 Homework Assignment 1

Satisfactory Essays
Open Document
Open Document
345 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Cmis102 Homework Assignment 1
CMIS102 Homework Assignment 1

Student Name: Class/Section: CMIS 102 Professor Name: Dr. Hung Dao Assignment due date: 5/27/2012

Problem definition: Calculate the monthly payment on a loan given the loan amount, the annual interest rate, and the total number of monthly payments.

A. Problem Analysis – Here are the input data, output data and processing step to convert input data into output data. 1. Input Data: a. Loan Amount (P) b. Annual percentage rate of interest (r) c. Number of monthly payments (N). 2. Output data: Monthly Payment (M) 3. Processing: The output M can be obtained from the input data by using the following formula: M = P * R* (1+R)^N/((1+R) ^N-1) where R =r/1200 B. Program Design – The program will consist of the following modules: Main Module Input Data Module (sub-module) Perform Calculations Module (sub-module) Output Data Module (sub-module) Main module Write “This program will compute the monthly payment based on the loan amount, the annual percentage rate of interest, and the number of monthly payments.” Declare P As Float Declare r As Float Declare N As Integer Declare M As Float Call Input Data Module Call Perform Calculations Module Call Output Data Module End Program

Input Data module Write “Please enter the loan amount: ” Input P Write “Please enter the annual percentage rate of interest: ” Input r Write “Please enter number of monthly payments: ” Input N Perform Calculations module Declare R As Float Set R = r / 1200 Set M = P * R * (1 + R)^ N / ((1 + R) ^ N – 1) Output Data module Write “The loan amount is: “ + P Write “The annual interest rate is: “ + r Write “The number of monthly payment is: “ + N Write “The monthly payment amount will be: “ + M B. Program Comments and Test Data –
Input: loan amount (P), annual interest rate ( r), number of monthly payments (N) P = 10,000 r = 5% N = 60 P = 30,000 r = 4% N = 60 P = 200,000 r = 3.75% N = 360 926.23 552.50 Expected output: Monthly Payment (M)

188.71

You May Also Find These Documents Helpful

  • Good Essays

    38. Calculating Loan Payments. You need a 30-years, fixed-rate mortgage to buy a new home for $250,000. Your mortgage bank will lend you the money at a 6.8 percent APR for this 360-month loan. However, you can only afford monthly payments of $1,200, so you offer to pay off any remaining loan balance at the end of the loan in the form of single balloon payment. How large will this balloon payment have to be for you to keep your monthly payments at $1,200?…

    • 441 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    Management would like to maintain a minimum cash balance of $5,000 at the end of each month. The company has an agreement with a local bank that allows the company to borrow in increments of $1,000 at the beginning of each month, up to a total loan balance of $50,000. The interest rate on these loans is 1% per month, and for simplicity, we will assume that interest is not compounded. The company would, as far as it is able, repay the loan plus accumulated interest at the end of the quarter.…

    • 434 Words
    • 4 Pages
    Satisfactory Essays
  • Satisfactory Essays

    3505 M2 Fall 2014 Soltn

    • 3355 Words
    • 15 Pages

    e. Apply RAROC to the data on the above loan. Calculate each component of RAROC.…

    • 3355 Words
    • 15 Pages
    Satisfactory Essays
  • Good Essays

    Business Math Unit 5

    • 704 Words
    • 3 Pages

    15 year loan - $575.00 mortgage payment, $31.25 taxes, $20.83 insurance. Total monthly payment $575.00+$31.25+20.83 = $627.08 per month…

    • 704 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Unit 9 Assignment

    • 796 Words
    • 4 Pages

    To find payment amounts, you may use Excel, the EZ Calculators app, or the tables in the Chapter if those tables have the needed values. When finding an APR, give an exact value using Excel or the EZ Calculators app. Show work.…

    • 796 Words
    • 4 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Hrm/531 Final Exam Paper

    • 807 Words
    • 4 Pages

    (a) Compute the monthly payment using the PMT function in Excel and then prepare an amortization table. Fully amortize the loan by going out to the last payment.…

    • 807 Words
    • 4 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Mat 221 Week 4 Assignment

    • 390 Words
    • 2 Pages

    P = $5670 and r = 3.5% = .035 Interest rate as a decimal number…

    • 390 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Mathl 104 Research Paper

    • 428 Words
    • 2 Pages

    Technology is pervading all levels of mathematics teaching and learning in our modern world, bringing ever more sharply into focus the change from traditional pencil and paper learning to a mixture of calculator, computer and pencil and paper learning environments. Currently the loan has 25 years remaining. Therefore to find out the P&I payment, you would plug in 300 for N (25x12), 5.75% for I, 0 for FV, and $112,242.47 for PV, and then press PMT which gives you the $706.12. However, we want to find out how much more money they have to pay to pay off the loan in 20 years instead of 25. Therefore change N to 240 (20x12) instead of 300. Then press PMT and we should get $788.04. Next, subtract the P&I payment they are making now (706.12) from $788.04, which tells you they need to pay $81.92 extra towards the principal each month to have the loan paid off in 20 years instead of 25.…

    • 428 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    2. Multiply the (principal + first quarter interest) by ¼ of the interest rate to…

    • 208 Words
    • 7 Pages
    Satisfactory Essays
  • Good Essays

    Programing Problems

    • 721 Words
    • 3 Pages

    Input NumberMonths End User Input Module Monthly Rate Module MonthlyRate = InterestRate/1200 End Monthly Rate Module Payment Calculation Module Payment = LoanAmt * MonthlyRate * (1 + MonthlyRate)^NumberMonths ÷ ((1 + MonthlyRate)^NumberMonths – 1) End Payment Calculation Module Display module Display “Your monthly payment will be” Payment “.”…

    • 721 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Exam Paper Afin253

    • 3460 Words
    • 14 Pages

    Question 2: You want to buy an apartment worth $500,000. You have saved a deposit of $50,000. The bank has agreed to lend you the $450,000 as a fully amortising mortgage with a term of 25 years. The interest rate is 6% pa and is not expected to change. What will be your monthly payments? (a) 1,500.00 (b) 2,250.00 (c) 2,855.79 (d) 2,899.36 (e) 35,202.02…

    • 3460 Words
    • 14 Pages
    Satisfactory Essays
  • Satisfactory Essays

    unit 3

    • 313 Words
    • 2 Pages

    9. Write a pseudocode statement that subtracts the variable Down Payment from the variable total and assigns the result to the variable due.…

    • 313 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Course Project

    • 271 Words
    • 12 Pages

    Weighted-Average Accumulated Expenditures X Interest Rate = Avoidable Interest $2,000,000 12% $240,000 1,800,000 10.38% 186,840 $3,800,000 $426,840 Weighted-average interest rate computation Principal Interest 10% short-term loan $1,600,000 $160,000 11% long-term loan 1,000,000 110,000 $2,600,000 $270,000…

    • 271 Words
    • 12 Pages
    Satisfactory Essays
  • Powerful Essays

    Putting the values into the excel function PMT(rate, nper, pv, [fv], [type]), one gets the yearly payment amount PMT = $84.14.…

    • 1735 Words
    • 7 Pages
    Powerful Essays
  • Good Essays

    Calculate the time you would take to pay the debt – Divide the repayment amount equally over a fixed time period.…

    • 655 Words
    • 3 Pages
    Good Essays