{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Loans","Loans(an)","Amortization Table","Amortization Table (an)"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"Loans","index":0,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["As a business owner of a Wooden Toy company, you need to buy a CNC Router Machine. The machine cost $500,000. You have been diligent, and from various banks you have gathered various loan offers."]
[{"$f":"\"The details of the loans are in columns \"&LEFT(ADDRESS(ROW(A13),COLUMN(A13),4))&\" to \"&LEFT(ADDRESS(ROW(F13),COLUMN(F13),4))&\" and in cells \"&ADDRESS(ROW(B8),COLUMN(B8),4)&\" and \"&ADDRESS(ROW(B9),COLUMN(B8),4)&\" and \"&ADDRESS(ROW(B10),COLUMN(B10),4)","v":"The details of the loans are in columns A to F and in cells B8 and B9 and B10"}]
[{"$f":"\"In column \"&LEFT(ADDRESS(ROW(G13),COLUMN(G13),4))&\", calculate the loan value (be sure to consider the down payment). In column \"&LEFT(ADDRESS(ROW(H13),COLUMN(H13),4))&\", calculate the monthly PMT. In column \"&LEFT(ADDRESS(ROW(I13),COLUMN(I13),4))&\", calculate the Actual Amount Borrowed (take into consideration the points and fees). In column \"&LEFT(ADDRESS(ROW(J13),COLUMN(J13),4))&\", calculate the APR based on the Actual Amount Borrowed. In column \"&LEFT(ADDRESS(ROW(K13),COLUMN(K13),4))&\", calculate the Payment with the balloon payment as listed in \"&ADDRESS(ROW(B10),COLUMN(B10),4)&\".\"","v":"In column G, calculate the loan value (be sure to consider the down payment). In column H, calculate the monthly PMT. In column I, calculate the Actual Amount Borrowed (take into consideration the points and fees). In column J, calculate the APR based on the Actual Amount Borrowed. In column K, calculate the Payment with the balloon payment as listed in B10."}]
[{"$f":"\"In cell \"&ADDRESS(ROW(A19),COLUMN(A19),4)&\" describe which loan you would select and why.\"","v":"In cell A19 describe which loan you would select and why."}]
[]
["Analyze Various Loans"]
[]
["Purchase Price",500000]
["Number of Compounding Periods/year",4]
["Optional Balloon Payment",100000]
[]
["Option#","Down Payment","Nominal Interest Rate/yr","Duration (yrs)","Points","Fees","Loan Value","Monthly Payment ","Actual Amount Borrowed","APR","Payment with Balloon"]
[1,0.15,0.08,30,2,450]
[2,0.18,7.9500000000000001E-2,25,1.75,375]
[3,0.17499999999999999,9.1499999999999998E-2,20,2.5,295]
[4,0.25,7.4999999999999997E-2,25,0,0]
[5,0.2,6.9500000000000006E-2,20,0,0]

{"sheet":"Loans(an)","index":1,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["As a business owner of a Wooden Toy company, you need to buy a CNC Router Machine. The machine cost $500,000. You have been diligent, and from various banks you have gathered various loan offers."]
[{"$f":"\"The details of the loans are in columns \"&LEFT(ADDRESS(ROW(A13),COLUMN(A13),4))&\" to \"&LEFT(ADDRESS(ROW(F13),COLUMN(F13),4))&\" and in cells \"&ADDRESS(ROW(B8),COLUMN(B8),4)&\" and \"&ADDRESS(ROW(B9),COLUMN(B8),4)&\" and \"&ADDRESS(ROW(B10),COLUMN(B10),4)","v":"The details of the loans are in columns A to F and in cells B8 and B9 and B10"}]
[{"$f":"\"In column \"&LEFT(ADDRESS(ROW(G13),COLUMN(G13),4))&\", calculate the loan value (be sure to consider the down payment). In column \"&LEFT(ADDRESS(ROW(H13),COLUMN(H13),4))&\", calculate the monthly PMT. In column \"&LEFT(ADDRESS(ROW(I13),COLUMN(I13),4))&\", calculate the Actual Amount Borrowed (take into consideration the points and fees). In column \"&LEFT(ADDRESS(ROW(J13),COLUMN(J13),4))&\", calculate the APR based on the Actual Amount Borrowed. In column \"&LEFT(ADDRESS(ROW(K13),COLUMN(K13),4))&\", calculate the Payment with the balloon payment as listed in \"&ADDRESS(ROW(B10),COLUMN(B10),4)&\".\"","v":"In column G, calculate the loan value (be sure to consider the down payment). In column H, calculate the monthly PMT. In column I, calculate the Actual Amount Borrowed (take into consideration the points and fees). In column J, calculate the APR based on the Actual Amount Borrowed. In column K, calculate the Payment with the balloon payment as listed in B10."}]
[{"$f":"\"In cell \"&ADDRESS(ROW(A19),COLUMN(A19),4)&\" describe which loan you would select and why.\"","v":"In cell A19 describe which loan you would select and why."}]
[]
["Analyze Various Loans"]
[]
["Purchase Price",500000]
["Number of Compounding Periods/year",4]
["Optional Balloon Payment",100000]
[]
["Option#","Down Payment","Nominal Interest Rate/yr","Duration (yrs)","Points","Fees","Loan Value","Monthly Payment ","Actual Amount Borrowed","Adjusted APR","Payment with Balloon"]
[1,0.15,0.08,30,2,450,{"$f":"B$8*(1-B13)","v":425000},{"$f":"PMT(C13/B$9,D13*B$9,G13)","v":-9370.4411764790202},{"$f":"G13*(1-E13/100)-F13","v":416050},{"$f":"RATE(D13*B$9,H13,I13)*B$9","v":8.2258681830240141E-2},{"$f":"PMT(C13/B$9,D13*B$9,G13,-B$10)","v":-9165.6314878957201}]
[2,0.18,7.9500000000000001E-2,25,1.75,375,{"$f":"B$8*(1-B14)","v":410000.00000000006},{"$f":"PMT(C14/B$9,D14*B$9,G14)","v":-9472.3725478622873},{"$f":"G14*(1-E14/100)-F14","v":402450.00000000006},{"$f":"RATE(D14*B$9,H14,I14)*B$9","v":8.1673961129457864E-2},{"$f":"PMT(C14/B$9,D14*B$9,G14,-B$10)","v":-9149.5377800909973}]
[3,0.17499999999999999,9.1499999999999998E-2,20,2.5,295,{"$f":"B$8*(1-B15)","v":412500},{"$f":"PMT(C15/B$9,D15*B$9,G15)","v":-11283.701258568646},{"$f":"G15*(1-E15/100)-F15","v":401892.5},{"$f":"RATE(D15*B$9,H15,I15)*B$9","v":9.5196944034930328E-2},{"$f":"PMT(C15/B$9,D15*B$9,G15,-B$10)","v":-10835.758529218672}]
[4,0.25,7.4999999999999997E-2,25,0,0,{"$f":"B$8*(1-B16)","v":375000},{"$f":"PMT(C16/B$9,D16*B$9,G16)","v":-8331.2664560220019},{"$f":"G16*(1-E16/100)-F16","v":375000},{"$f":"RATE(D16*B$9,H16,I16)*B$9","v":7.4999999999999734E-2},{"$f":"PMT(C16/B$9,D16*B$9,G16,-B$10)","v":-7984.5954010828009}]
[5,0.2,6.9500000000000006E-2,20,0,0,{"$f":"B$8*(1-B17)","v":400000},{"$f":"PMT(C17/B$9,D17*B$9,G17)","v":-9292.2696051709954},{"$f":"G17*(1-E17/100)-F17","v":400000},{"$f":"RATE(D17*B$9,H17,I17)*B$9","v":6.9500000000000131E-2},{"$f":"PMT(C17/B$9,D17*B$9,G17,-B$10)","v":-8706.702203878247}]
[]
["If I did not need as much cash up front and 20 years was appropriate, I would go with Option #5 because the financing fees are low and the Adjusted APR is lowest."]

{"sheet":"Amortization Table","index":2,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["You just took out a business loan for 15 years at an annual rate of 9.25% compounded semi-annually. You borrowed $100,000 and a $25,000 balloon payment is due on the last day. The payments are made at the end of each period. Create an amortization table that shows how much of each payment is a reduction in principal and how much is interest payment."]

{"sheet":"Amortization Table (an)","index":3,"n_rows":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":true,"merged":[]}
["You just took out a business loan for 15 years at an annual rate of 9.25% compounded semi-annually. You borrowed $100,000 and a $25,000 balloon payment is due on the last day. The payments are made at the end of each period. Create an amortization table that shows how much of each payment is a reduction in principal and how much is interest payment."]
[]
["Loan Amount",100000]
["Annual Rate",9.2499999999999999E-2]
["Number of Compounding Periods Per Year",2]
["Period Rate",{"$f":"B4/B5","v":4.6249999999999999E-2}]
["Years",15]
["Total Periods",{"$f":"B7*B5","v":30}]
["Payments at end of each month","0 or defualt"]
["Ballonn Paymnet at the end",25000]
["PMT",{"$f":"PMT(B6,B8,B3,-B10)","v":-5828.559156718793}]
[]
[null,null,"Periods","PMT","Interest","Reduction In Loan","Balance"]
[null,null,0,null,null,null,{"$f":"B3","v":100000}]
[null,null,1,{"$f":"-$B$11","v":5828.559156718793},{"$f":"G14*B$6","v":4625},{"$f":"D15-E15","v":1203.559156718793},{"$f":"G14-F15","v":98796.440843281205}]
[null,null,2,5828.559156718793,{"$f":"G15*B$6","v":4569.3353890017561},{"$f":"D16-E16","v":1259.2237677170369},{"$f":"G15-F16","v":97537.217075564171}]
[null,null,3,5828.559156718793,4511.0962897448426,1317.4628669739504,96219.754208590224]
[null,null,4,5828.559156718793,4450.1636321472979,1378.3955245714951,94841.358684018734]
[null,null,5,5828.559156718793,4386.4128391358663,1442.1463175829267,93399.212366435808]
[null,null,6,5828.559156718793,4319.7135719476564,1508.8455847711366,91890.366781664678]
[null,null,7,5828.559156718793,4249.9294636519917,1578.6296930668013,90311.737088597874]
[null,null,8,5828.559156718793,4176.9178403476517,1651.6413163711413,88660.095772226734]
[null,null,9,5828.559156718793,4100.5294294654868,1728.0297272533062,86932.066044973428]
[null,null,10,5828.559156718793,4020.608054580021,1807.9511021387721,85124.114942834654]
[null,null,11,5828.559156718793,3936.9903161061029,1891.5688406126901,83232.546102221968]
[null,null,12,5828.559156718793,3849.5052572277659,1979.0538994910271,81253.492202730937]
[null,null,13,5828.559156718793,3757.9740143763056,2070.5851423424874,79182.907060388447]
[null,null,14,5828.559156718793,3662.2094515429658,2166.3497051758272,77016.557355212615]
[null,null,15,5828.559156718793,3562.0157776785836,2266.5433790402094,74750.013976172399]
[null,null,16,5828.559156718793,3457.1881463979735,2371.3710103208196,72378.642965851584]
[null,null,17,5828.559156718793,3347.5122371706357,2481.0469195481573,69897.596046303428]
[null,null,18,5828.559156718793,3232.7638171415333,2595.7953395772597,67301.800706726164]
[null,null,19,5828.559156718793,3112.7082826860851,2715.8508740327079,64585.949832693455]
[null,null,20,5828.559156718793,2987.1001797620725,2841.4589769567206,61744.490855736738]
[null,null,21,5828.559156718793,2855.6827020778242,2972.8764546409689,58771.614401095772]
[null,null,22,5828.559156718793,2718.1871660506795,3110.3719906681135,55661.242410427658]
[null,null,23,5828.559156718793,2574.3324614822791,3254.2266952365139,52407.015715191141]
[null,null,24,5828.559156718793,2423.8244768275904,3404.7346798912026,49002.281035299937]
[null,null,25,5828.559156718793,2266.3554978826219,3562.2036588361711,45440.077376463763]
[null,null,26,5828.559156718793,2101.6035786614489,3726.9555780573442,41713.121798406421]
[null,null,27,5828.559156718793,1929.2318831762968,3899.3272735424962,37813.794524863923]
[null,null,28,5828.559156718793,1748.8879967749565,4079.6711599438368,33734.123364920088]
[null,null,29,5828.559156718793,1560.2032056275541,4268.3559510912391,29465.767413828849]
[null,null,30,5828.559156718793,1362.7917428895842,4465.7674138292086,24999.99999999964]