CPAN112_CompoundInterest_Tyler_Escobar

docx

School

Humber College *

*We aren’t endorsed by this school

Course

112

Subject

Mathematics

Date

Feb 20, 2024

Type

docx

Pages

9

Uploaded by EarlPantherMaster1046

Report
Fundamentals of Numeric Computing CPAN 112 Compound Interest Program and Assignment Please read the following instruction very carefully before answering any questions: Please read all the questions very carefully. Please provide your answers in the boxes below each question, and do not change the text colour. Your answer MUST show the solution procedure. There is no credit if you only state the final answer. Please highlight your final answer to each question. Please keep the naming conventions requested in this lab and each question. Once you complete your lab, rename your word document file to the ( CPAN112_CompoundInterest_FirstName_LastName ). Replace FirstName and LastName with your first name and last name, respectively. It will be a 10% mark deduction if you do not follow the guidelines mentioned above.
1) For a sum of money borrowed at 7.25% compounded bi-weekly for 84 months, state [10 points] a. the nominal annual rate of interest ( j ); b. the number of compounding interest periods per year ( m ); c. the periodic rate of interest ( i ); d. the number of compounding periods in the term ( n ); e. the compounding factor (1 + i ) n ; f. the numerical value of the compounding factor. j = 7.25%/0.0725; the nominal annual rate m = Bi-weekly = twice per month = 2 m = 52 weeks per year, 52/2 = 26 i = number of years in term * number of compounding periods per year i = j/m i = 0.0725/26 n = number of years in term * m n = 84 months = 7 years (7 * 26) FV = PV(1+I) n (1 + i) n = (1 + 0.0725/26) 7 * 26 Numerical Value is 1.65996039 2) You have a line of credit loan with Scotiabank. The initial loan balance was $6000.00. Payments of $2000.00 and $1500.00 were made after five months and ten months, respectively. At the end of one year, you borrowed an additional $3200.00. Eight months later, the line of credit loan was converted into a collateral mortgage loan. What was the amount of the mortgage if the line of credit interest was 6.15% compounded monthly? [20 points] Initial Loan Balance = 6000.00 2000.00 payment after 5 months 1500.00 payment after 10 months Addition 3200.00 loan added
Eight month later credit loan converted to collateral mortgage loan 6.15 % annual rate Compounded monthly, once per month FV = PV(1 + i) n FV = 6000(1 + i) n I = j/m J = 6.15%/0.0615 M = 12 I = 0.0615/12 N = 12 * 5/12 = 5 FV = 6000(1 + 0.0615/12) 5 FV = 6000(1.025889006) FV = 6155.33 6155.33 - 2000 = 4155.33 FV = 4155.33 (1 + 0.0615/12) 5 FV = 4262.91 4262.91 - 1500 = 2762.91 FV = 2762.91 (1 + 0.0615/12) n N = 12 * 2/12 = 2 FV = 2762.91 (1 + 0.0615/12) 2 FV = 2791.302397 2791.30 + 3200 = 5991.30 FV = 5991.30 (1 + 0.0615/12) n N = 12 * 8/12 = 8 FV = 5991.30 (1 + 0.0615/12) 8 FV = 6241.40 The amount of mortgage after the eight months would be $6241.40
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
3) Harpreet's parents deposited a lump sum of money into a savings account for him on his tenth birthday at an interest rate of 5% compounded semi- annually. Three years later, they opened a new account for him. They deposited $5000 to this new account and transferred over the balance from th e original account. The new account paid interest at 4.95% compounded daily. How much money was originally invested if Harpreet had $15 000.67 in the account on the day he turned 19? [20 points] 1500.67 = PV(1 + i) n I = j/m J = 4.95%/0.0495 M = daily/365 I = 0.0495/365 N = 365 * 6 = 2190 15000.67 = PV(1 + 0.0495/365) 2190 PV = 15000.67/1 + 0.0495/365) 2190 (Finding Value at age 13) PV = 11146.38 11146.38 - 5000 = 6146.38 PV = 6146.38/(1 + i) n 4) On April 15, 2023, a 10-year note dated June 15, 2018, is discounted at 10% compounded quarterly. If the face value of the note is $4000 and interest is 8% compounded quarterly, calculate the compound discount. [20 points] FV = PV(1 + I) n PV = FV/(1 + I) n 4000 = FV I = j/m J = 8% or 0.08 M = quarterly = 4 I = 0.08/4 N = 4 x 10 years = 40 PV = 4000/(1 + 0.08/4) 40 PV = 1811.56
Compund Discount = Face Value – Present Value = CD = 4000 – 1811.56 CD = 2188.43 5) Scheduled payments of $1500 due today and $1500 due in three years are to be replaced by two payments. The first payment is due in one year and the second payment, which is double the size of the first payment, is due in five years. Determine the size of each payment if interest is 2.9% compounded weekly. [20 points] PV = FV/(1 + I) n FV = 1500 I = j/m J = 2.9% or 0.029 M = weekly = 7, 52 weeks per year I = 0.029/52 N1 = 0 * 52 = 0 (due today) N2 = 3 * 52 = 156 PV1 = 1500/(1 + 0.029/52) 0 PV1 = 1500 PV2 = 1500/(1 + 0.029/52) 156 PV2 = 1375.05 1500 + 1375.05 = 2875.05 New Future Values NFV + 2(NFV) = 2875.05 3NFV = 2875.05 3x/3 = 2875.05/3 X = 958.35 FV1 = 958.35(1 + 0.029/52) 1*52 FV1 = 958.35(1 + 0.029/52) 52 FV1 = 986.54 FV2 = 2 * 958.35(1 + 0.029/52) 52 * 5
FV2 = 1916.7(1 + 0.029/52) 260 FV2 =2215.691489 6) Write a Python program to calculate and display the result of Question 2 [10 points] Copy and paste your Python code here: futureValue = 0 presentValue = 0 interestRate = 0 numberOfPeriods = 0 typeOfPeriod = 0 i = 0 n = 0 x = 1 while x < 2 : presentValue = float ( input ( "First, Enter in the Present Value: " )) interestRate = float ( input ( "Second, Enter in the Interest Rate: " )) typeOfPeriod = str ( input ( "Before you Enter in the period, whats the time frame (Annually = t,semi-annually = 2, " "quarterly = 4, monthly = 12, daily = 365): " ).upper()) numberOfPeriods = float ( input ( "Lastly, Enter in the Length of the Period " )) interestRate = interestRate / 100 print ( 'Good Lets do the Equation' ) if typeOfPeriod == "ANNUALLY" : i = interestRate / 1 n = numberOfPeriods * 1 elif typeOfPeriod == "SEMI-ANNUALLY" : i = interestRate / 2 n = numberOfPeriods * 2 elif typeOfPeriod == "QUARTERLY" : i = interestRate / 4 n = numberOfPeriods * 4 elif typeOfPeriod == "MONTHLY" : i = interestRate / 12 n = numberOfPeriods * 12 elif typeOfPeriod == "DAILY" : i = interestRate / 365 n = numberOfPeriods * 365 else : print ( "Sorry but the entered in Period Type doesn't work, try again" ) break firstHalf = ( 1 + i) ** n futureValue = presentValue * firstHalf futureValue = futureValue - 2000
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
futureValue = round (futureValue) print (futureValue) print ( "Now well check how much it became before the second payment" ) numberOfPeriods = float ( input ( "Lastly, Enter in the New Length of the Period " )) interestRate = interestRate / 100 print ( 'Good Lets do the Equation' ) if typeOfPeriod == "ANNUALLY" : i = interestRate / 1 n = numberOfPeriods * 1 elif typeOfPeriod == "SEMI-ANNUALLY" : i = interestRate / 2 n = numberOfPeriods * 2 elif typeOfPeriod == "QUARTERLY" : i = interestRate / 4 n = numberOfPeriods * 4 elif typeOfPeriod == "MONTHLY" : i = interestRate / 12 n = numberOfPeriods * 12 elif typeOfPeriod == "DAILY" : i = interestRate / 365 n = numberOfPeriods * 365 else : print ( "Sorry but the entered in Period Type doesn't work, try again" ) break firstHalf = ( 1 + i) ** n futureValue = futureValue * firstHalf futureValue = futureValue - 1500 print (futureValue) print ( "Now well check how much it became before the loan" ) numberOfPeriods = float ( input ( "Lastly, Enter in the New Length of the Period " )) interestRate = interestRate / 100 print ( 'Good Lets do the Equation' ) if typeOfPeriod == "ANNUALLY" : i = interestRate / 1 n = numberOfPeriods * 1 elif typeOfPeriod == "SEMI-ANNUALLY" : i = interestRate / 2 n = numberOfPeriods * 2 elif typeOfPeriod == "QUARTERLY" : i = interestRate / 4 n = numberOfPeriods * 4 elif typeOfPeriod == "MONTHLY" : i = interestRate / 12 n = numberOfPeriods * 12 elif typeOfPeriod == "DAILY" : i = interestRate / 365 n = numberOfPeriods * 365
else : print ( "Sorry but the entered in Period Type doesn't work, try again" ) firstHalf = ( 1 + i) ** n futureValue = firstHalf * futureValue futureValue = futureValue + 3200 futureValue = round (futureValue) print (futureValue) print ( "Now well check how much it became after 8 months" ) n = 8 * 12 firstHalf = ( 1 + i) ** n futureValue = firstHalf * futureValue futureValue = round (futureValue) txt = "The Interest Earned over the {0} {1} period is {2%.2f}" print (txt.format(numberOfPeriods, typeOfPeriod, futureValue)) Copy and paste a screenshot of your Python code output here: First, Enter in the Present Value: 6000 Second, Enter in the Interest Rate: 6.15 Before you Enter in the period, whats the time frame (Annually = t,semi- annually = 2, quarterly = 4, monthly = 12, daily = 365): monthly Lastly, Enter in the Length of the Period 5 Good Lets do the Equation 6154 Now well check how much it became before the second payment Lastly, Enter in the New Length of the Period 5 Good Lets do the Equation 4673 Now well check how much it became before the loan Lastly, Enter in the New Length of the Period 2 Good Lets do the Equation 7873 Now well check how much it became after 8 months The Interest Earned over the 2.0 MONTHLY period is 7873 Deliverables :
The word document file ( CPAN112_CompoundInterest_FirstName_LastName ) contains your solution.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help