1 0 0 0 0 0 0 0 1 1 1 1 1 0 1 33.TSCTitle 42.TSCTitle 43.TSCTitle 44.TSCTitle 45.TSCTitle 46.TSCTitle 36.TSCTitle 39.TSCTitle 40.TSCTitle 41.TSCTitle C:\Documents and Settings\Joan Thirion\My Documents\Camtasia Studio\inventory4a_pagesetup.camrec C:\Documents and Settings\Joan Thirion\My Documents\Camtasia Studio\inventory4b_amountanddate.camrec C:\Documents and Settings\Joan Thirion\My Documents\Camtasia Studio\inventory4c_rates.camrec C:\Documents and Settings\Joan Thirion\My Documents\Camtasia Studio\inventory4d_years.camrec C:\Documents and Settings\Joan Thirion\My Documents\Camtasia Studio\inventory4e_labels.camrec C:\Documents and Settings\Joan Thirion\My Documents\Camtasia Studio\inventory4f_pmt.camrec C:\Documents and Settings\Joan Thirion\My Documents\Camtasia Studio\inventory4fg_copypmt.camrec C:\Documents and Settings\Joan Thirion\My Documents\Camtasia Studio\inventory4h_boldcenter.camrec C:\Documents and Settings\Joan Thirion\My Documents\Camtasia Studio\inventory4i_borders.camrec C:\Documents and Settings\Joan Thirion\My Documents\Camtasia Studio\inventory4j_landscape.camrec TSCRec://c:\documents and settings\joan thirion\my documents\camtasia studio\inventory4b_amountanddate.camrec!Screen_Stream.avi 0 3 8 1198070948 1796737614 0 24 804 540 698000000 0 0 0 698000000 15.000015 1.000000 65535 -1 65535 65535 -1 65535 65535 6 inventory4b_amountanddate.camrec!Screen_Stream 0 51.TSCTitle 0 2 4 1148070948 1198070948 0 32 804 540 0 0 0 0 0 10.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 5 51 0 TSCRec://c:\documents and settings\joan thirion\my documents\camtasia studio\inventory4a_pagesetup.camrec!Screen_Stream.avi 0 1 8 94297248 1148070948 0 24 804 540 1288000000 48226300 0 48226300 1288000000 15.000015 1.000000 65535 -1 65535 65535 -1 65535 65535 4 inventory4a_pagesetup.camrec!Screen_Stream 0 50.TSCTitle 0 0 4 0 94297248 0 32 804 540 0 0 0 0 0 10.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 3 50 0 53.TSCTitle 0 4 4 1796737614 1846737614 0 32 804 540 0 0 0 0 0 10.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 7 53 0 TSCRec://c:\documents and settings\joan thirion\my documents\camtasia studio\inventory4c_rates.camrec!Screen_Stream.avi 0 5 8 1846737614 2305397614 0 24 804 540 458660000 0 0 0 458660000 15.000015 1.000000 65535 -1 65535 65535 -1 65535 65535 8 inventory4c_rates.camrec!Screen_Stream 0 54.TSCTitle 0 6 4 2305397614 2355397614 0 32 804 540 0 0 0 0 0 10.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 9 54 0 TSCRec://c:\documents and settings\joan thirion\my documents\camtasia studio\inventory4d_years.camrec!Screen_Stream.avi 0 7 8 2355397614 3179397614 0 24 804 540 824000000 0 0 0 824000000 15.000015 1.000000 65535 -1 65535 65535 -1 65535 65535 10 inventory4d_years.camrec!Screen_Stream 0 55.TSCTitle 0 8 4 3179397614 3229397614 0 32 804 540 0 0 0 0 0 10.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 11 55 0 TSCRec://c:\documents and settings\joan thirion\my documents\camtasia studio\inventory4e_labels.camrec!Screen_Stream.avi 0 9 8 3229397614 3564727614 0 24 804 540 335330000 0 0 0 335330000 15.000015 1.000000 65535 -1 65535 65535 -1 65535 65535 12 inventory4e_labels.camrec!Screen_Stream 0 56.TSCTitle 0 10 4 3564727614 3681521724 0 32 804 540 0 0 0 0 0 10.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 13 56 0 TSCRec://c:\documents and settings\joan thirion\my documents\camtasia studio\inventory4f_pmt.camrec!Screen_Stream.avi 0 11 8 3681521724 4676181724 0 24 804 540 994660000 0 0 0 994660000 15.000015 1.000000 65535 -1 65535 65535 -1 65535 65535 14 inventory4f_pmt.camrec!Screen_Stream 0 57.TSCTitle 0 12 4 4676181724 4738436712 0 32 804 540 0 0 0 0 0 10.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 15 57 0 TSCRec://c:\documents and settings\joan thirion\my documents\camtasia studio\inventory4fg_copypmt.camrec!Screen_Stream.avi 0 13 8 4738436712 5527766712 0 24 804 540 789330000 0 0 0 789330000 15.000015 1.000000 65535 -1 65535 65535 -1 65535 65535 16 inventory4fg_copypmt.camrec!Screen_Stream 0 58.TSCTitle 0 14 4 5527766712 5577766712 0 32 804 540 0 0 0 0 0 10.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 17 58 0 TSCRec://c:\documents and settings\joan thirion\my documents\camtasia studio\inventory4h_boldcenter.camrec!Screen_Stream.avi 0 15 8 5577766712 5922426712 0 24 804 540 344660000 0 0 0 344660000 15.000015 1.000000 65535 -1 65535 65535 -1 65535 65535 18 inventory4h_boldcenter.camrec!Screen_Stream 0 59.TSCTitle 0 16 4 5922426712 5972426712 0 32 804 540 0 0 0 0 0 10.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 19 59 0 TSCRec://c:\documents and settings\joan thirion\my documents\camtasia studio\inventory4i_borders.camrec!Screen_Stream.avi 0 17 8 5972426712 6694426712 0 24 804 540 722000000 0 0 0 722000000 15.000015 1.000000 65535 -1 65535 65535 -1 65535 65535 20 inventory4i_borders.camrec!Screen_Stream 0 60.TSCTitle 0 18 4 6694426712 6744426712 0 32 804 540 0 0 0 0 0 10.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 21 60 0 TSCRec://c:\documents and settings\joan thirion\my documents\camtasia studio\inventory4j_landscape.camrec!Screen_Stream.avi 0 19 8 6744426712 6978426712 0 24 804 540 234000000 0 0 0 234000000 15.000015 1.000000 65535 -1 65535 65535 -1 65535 65535 22 inventory4j_landscape.camrec!Screen_Stream 0 0 0x000003E9 1-3 Start your finance plan sheet 1 0 3 0 0x000003EA 4 Enter amount to finance 1 0 5 0 0x000003EB 7 Merge C3 to F3 and write “Rates” and bold and center it. 1 0 7 0 0x000003EC 8 Merge A5 to A8 and write “Years” 1 0 9 0 0x000003ED 9 - Enter rates and years 1 0 11 0 0x000003EE 10 Calculate the payment amount 1 0 13 0 0x000003EF 11 Adjust the formula so it can be copied to the other cells in the table 1 0 15 0 0x000003F0 12 -13 bold and center 1 0 17 0 0x000003F1 14 place borders 1 0 19 0 0x000003F2 15 Set it to print landscape so that it doesn't break into 2 pages 1 0 21 0 3 0 0 584000000 683333334 0 0 1 0 0 1102000000 1288000000 0 0 0 0 0 0 19645260 2 0 10 0 0 116794110 207162306 2 0 12 0 0 62254988 113332664 2 46 15 Set it to print landscape so that it doesn't break into 2 pages 0x00FFFFFF 2 1 1 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\sb100\sa100\qc\f0\fs24 Set it to print landscape so that it doesn't break into 2 pages\par \pard\qc\par } 10.00 10.00 620.00 460.00 1 1 640 480 45 14 place borders 0x00FFFFFF 2 1 1 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\sb100\sa100\qc\f0\fs24 Put gridlines around the years and rates and all the payments. \par Below the year and rate labels, place a double line.\par \pard\par } 10.00 10.00 620.00 460.00 1 1 640 480 44 12 -13 bold and center 0x00FFFFFF 2 1 1 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\sb100\sa100\qc\f0\fs24 Bold all labels.\par Center everything in columns B through F.\par \pard\par } 10.00 10.00 620.00 460.00 1 1 640 480 43 11 Adjust the formula so it can be copied to the other cells in the table 0x00FFFFFF 2 1 1 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\sb100\sa100\qc\f0\fs24 Adjust the formula so it can be copied to the other cells in the table\par \pard\par } 10.00 10.00 620.00 460.00 1 1 640 480 42 10 Calculate the payment amount 0x00FFFFFF 2 1 1 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fcharset0 Times New Roman;}{\f1\froman\fprq2\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\sb100\sa100\f0\fs24 Calculate the payment amount for the loan needed for each interest rate/ year combination. (Loans are compounded annually.) This should be done be creating the formula once, and copying it to all the other cells in the grid. The payment should be formatted as currency. Do not enter the formula more than once.\par \pard\f1\fs36\par } 10.00 10.00 620.00 460.00 1 1 640 480 41 9 - Enter rates and years 0x00FFFFFF 2 1 1 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman;}{\f1\froman\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\sb100\sa100\qc\f0\fs36 In C4-F4, enter the rates 1%, 5%, 10% and 15% \par and in B5-B8, enter the years 1, 3, 4 and 5. \f1\fs24\par \pard\par } 10.00 10.00 620.00 460.00 1 1 640 480 40 8 Merge A5 to A8 and write “Years” 0x00FFFFFF 2 1 1 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\sb100\sa100\qc\f0\fs24 Merge A5 to A8 and write \ldblquote Years\rdblquote \par and bold and center that. Turn \ldblquote Years\rdblquote so it prints vertically. \par \pard\par } 10.00 10.00 620.00 460.00 1 1 640 480 39 7 Merge C3 to F3 and write “Rates” and bold and center it. 0x00FFFFFF 2 1 1 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\sb100\sa100\qc\f0\fs24 Merge C3 to F3 and write \ldblquote Rates\rdblquote and bold and center it.\par \par Highlight C3 to F3 Choose format / cells and choose the alignment tab. \par Keep clicking the merge cells box until it is checked. \par Hit to accept it. \par Type \ldblquote Rates\rdblquote . \par Click the bold and center buttons \par } 10.00 10.00 620.00 460.00 1 1 640 480 36 4 -6 Enter amount to finance and date 0x00FFFFFF 2 1 1 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\sb100\sa100\qc\f0\fs24 On the first line, show \par " Amount I need to finance" \par and in the cell next to it, \par show any amount formatted as currency. \par \par Choose and amount you would like to borrow.\par (Do not use 750, the same as the example.) \par \pard\qc\par Then, enter the date you need it by.\par } 10.00 10.00 620.00 460.00 1 1 640 480 33 1. Heading: "FINANCE PLAN FOR " <your name>" 0x00FFFFFF 2 1 1 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fcharset0 Times New Roman;}{\f1\froman\fprq2\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\sb100\sa100\qc\f0\fs24 You will be creating a new sheet to calculate \par how you will finance purchases for all the stuff\par you want to buy for your inventory sheet. \par \par Open a new sheet and set the \par Heading: "FINANCE PLAN FOR " <your name>"\par \pard\qc\i\f1\fs40\par } 10.00 10.00 620.00 460.00 1 1 640 480 51 4 Enter amount to finance 0x00FFFFFF 2 1 1 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\sb100\sa100\qc\f0\fs24 On the first line, show \par " Amount I need to finance" \par and in the cell next to it, \par show any amount formatted as currency. \par Just choose any amount you would love to borrow.\par (Do not use 750, the same as the example.) \par \pard\qc\par } 10.00 10.00 620.00 460.00 1 1 640 480 50 1. Heading: "FINANCE PLAN FOR " <your name>" 0x00FFFFFF 2 1 1 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fcharset0 Times New Roman;}{\f1\froman\fprq2\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\sb100\sa100\qc\f0\fs24 You will be creating a new sheet to calculate \par how you will finance purchases for all the stuff\par you want to buy for your inventory sheet. \par \par Open a new sheet and set the \par Heading: "FINANCE PLAN FOR " <your name>"\par \pard\qc\i\f1\fs40\par } 10.00 10.00 620.00 460.00 1 1 640 480 53 7 Merge C3 to F3 and write “Rates” and bold and center it. 0x00FFFFFF 2 1 1 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\sb100\sa100\qc\f0\fs24 Merge C3 to F3 and write \ldblquote Rates\rdblquote and bold and center it.\par \par Highlight C3 to F3 Choose format / cells and choose the alignment tab. \par Keep clicking the merge cells box until it is checked. \par Hit to accept it. \par Type \ldblquote Rates\rdblquote . \par Click the bold and center buttons \par } 10.00 10.00 620.00 460.00 1 1 640 480 54 8 Merge A5 to A8 and write “Years” 0x00FFFFFF 2 1 1 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\sb100\sa100\qc\f0\fs24 Merge A5 to A8 and write \ldblquote Years\rdblquote \par and bold and center that. Turn \ldblquote Years\rdblquote so it prints vertically. \par \pard\par } 10.00 10.00 620.00 460.00 1 1 640 480 55 9 - Enter rates and years 0x00FFFFFF 2 1 1 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman;}{\f1\froman\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\sb100\sa100\qc\f0\fs36 In C4-F4, enter the rates 1%, 5%, 10% and 15% \par and in B5-B8, enter the years 1, 3, 4 and 5. \f1\fs24\par \pard\par } 10.00 10.00 620.00 460.00 1 1 640 480 56 10 Calculate the payment amount 0x00FFFFFF 2 1 1 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fcharset0 Times New Roman;}{\f1\froman\fprq2\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\sb100\sa100\f0\fs24 Calculate the payment amount for the loan needed for each interest rate/ year combination. (Loans are compounded annually.) This should be done be creating the formula once, and copying it to all the other cells in the grid. The payment should be formatted as currency. Do not enter the formula more than once.\par \pard\f1\fs36\par } 10.00 10.00 620.00 460.00 1 1 640 480 57 11 Adjust the formula so it can be copied to the other cells in the table 0x00FFFFFF 2 1 1 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\sb100\sa100\qc\f0\fs24 Adjust the formula so it can be copied to the other cells in the table\par \pard\par } 10.00 10.00 620.00 460.00 1 1 640 480 58 12 -13 bold and center 0x00FFFFFF 2 1 1 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\sb100\sa100\qc\f0\fs24 Bold all labels.\par Center everything in columns B through F.\par \pard\par } 10.00 10.00 620.00 460.00 1 1 640 480 59 14 place borders 0x00FFFFFF 2 1 1 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\sb100\sa100\qc\f0\fs24 Put gridlines around the years and rates and all the payments. \par Below the year and rate labels, place a double line.\par \pard\par } 10.00 10.00 620.00 460.00 1 1 640 480 60 15 Set it to print landscape so that it doesn't break into 2 pages 0x00FFFFFF 2 1 1 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fcharset0 Times New Roman;}} \viewkind4\uc1\pard\sb100\sa100\qc\f0\fs24 Set it to print landscape so that it doesn't break into 2 pages\par \pard\qc\par } 10.00 10.00 620.00 460.00 1 1 640 480 32 0 0 1