{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Banking"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Banking","index":0,"n_rows":59,"n_cols":49,"rows_kept":59,"cut":false,"hidden":false,"merged":[[58,10,58,13],[22,10,22,13],[1,1,5,42],[13,10,13,13],[31,10,31,13],[40,10,40,13],[49,10,49,13]]}
[]
[null,"N4 Lifeskills - Banking                                                                                                                                                                                                     Created by Mr.Lafferty@mathsrevision.com                                                                                                                                                          "]
[]
[]
[]
[]
[]
[null,{"$f":"\"Q1.  David invests £\"&AV9&\" in the bank for 1 year. The interest rate is \"&AV10&\"% per annum.\"","v":"Q1.  David invests £810 in the bank for 1 year. The interest rate is 4% per annum."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(500-45)+45,0)*10","v":810}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(9-2)+2,1)","v":4}]
[]
[null,null,"How much will he have in total in the bank after 1 year to the nearest penny?"]
[]
[null,null,null,null,null,null,null,null,null,"£",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(AV9+AV10/100*AV9,2)","v":842.4}]
[]
[]
[null,{"$f":"\"Q2.  Josh invests £\"&AV18&\" in the bank for \"&AW18&\" months. The interest rate is \"&AV19&\"% per annum.\"","v":"Q2.  Josh invests £320 in the bank for 10 months. The interest rate is 5.7% per annum."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(90-11)+11,0)*10","v":320},{"$f":"ROUND(RAND()*(11-3)+3,0)","v":10}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(9-2)+2,1)","v":5.7}]
[]
[null,null,{"$f":"\"How much will he have in total in the bank after \"&AW18&\" months to the nearest penny?\"","v":"How much will he have in total in the bank after 10 months to the nearest penny?"}]
[]
[null,null,null,null,null,null,null,null,null,"£",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND((AV18+(AW18/12*AV19/100*AV18)),2)","v":335.2}]
[]
[]
[null,{"$f":"\"Q3.  Robert uses his credit card to pay for a new TV costing £\"&AV27&\". The APR charge is \"&AW27&\"%.\"","v":"Q3.  Robert uses his credit card to pay for a new TV costing £730. The APR charge is 31%."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(150-60)+60,0)*10","v":730},{"$f":"ROUND(RAND()*(40-24)+24,0)","v":31}]
[]
[]
[null,null,"How much does he owe after 1 month to the nearest penny ?"]
[]
[null,null,null,null,null,null,null,null,null,"£",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND((AV27+(AW27/100*AV27/12)),2)","v":748.86}]
[]
[]
[null,{"$f":"\"Q4.  Erin uses her credit card to pay for a new kitchen costing £\"&AV36&\". The APR charge is \"&AW36&\"%.\"","v":"Q4.  Erin uses her credit card to pay for a new kitchen costing £5130. The APR charge is 35%."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(1000-400)+400,0)*10","v":5130},{"$f":"ROUND(RAND()*(40-30)+30,0)","v":35}]
[]
[]
[null,null,"How much does she owe after 1 month to the nearest penny ?"]
[]
[null,null,null,null,null,null,null,null,null,"£",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND((AV36+(AW36/100*AV36/12)),2)","v":5279.63}]
[]
[]
[null,{"$f":"\"Q5.  Roisin borrows  £\"&AV45&\" to pay for a holiday in the Maldives. She will repay it back over a year.\"","v":"Q5.  Roisin borrows  £2370 to pay for a holiday in the Maldives. She will repay it back over a year."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(500-180)+180,0)*10","v":2370},{"$f":"ROUND(RAND()*(40-30)+30,0)","v":34}]
[null,null,{"$f":"\"The APR is \"&AW45&\"%.\"","v":"The APR is 34%."}]
[]
[null,null,"How much will her monthly payments be to the nearest penny ?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND((AV45+(AW45/100*AV45)),2)","v":3175.8}]
[null,null,null,null,null,null,null,null,null,"£",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP(AV49/12,2)","v":264.64999999999998}]
[]
[]
[null,{"$f":"\"Q6.  Ryan borrows  £\"&AV54&\" to pay for a second hand car. He will repay it back over a year.\"","v":"Q6.  Ryan borrows  £4860 to pay for a second hand car. He will repay it back over a year."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(500-180)+180,0)*10","v":4860},{"$f":"ROUND(RAND()*(40-30)+30,0)","v":36}]
[null,null,{"$f":"\"The APR is \"&AW54&\"%.\"","v":"The APR is 36%."}]
[]
[null,null,"How much will his monthly payments be to the nearest penny ?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND((AV54+(AW54/100*AV54)),2)","v":6609.6}]
[null,null,null,null,null,null,null,null,null,"£",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP(AV58/12,2)","v":550.79999999999995}]