Dive In Company was started several years ago by two diving instructors. The company's comparative balance sheets and income statement, as well as additional information, are presented below. Current Year Previous Year Balance Sheet at December 31 Cash Accounts Receivable Prepaid Rent Total Assets Salaries and Wages Payable Common Stock Retained Earnings Total Liabilities and Stockholders' Equity Income Statement Service Revenue Salaries and Wages Expense Rent and Office Expenses Net Income $ 3,200 1,000 100 $ 4,300 $ 350 1,200 2,750 $ 4,300 $ 4,800 500 50 $ 4,550 $ 1,100 1,000 2,450 $ 4,550 $ 33,950 30,000 3,650 $ 300 Additional Data: a. Rent is paid in advance each month, and Office Expenses are paid in cash as incurred. b. An owner contributed capital by paying $200 cash in exchange for the company's stock. Required: 1. Prepare the statement of cash flows for the current year ended December 31 using the direct method. (Amounts to be deducted should be indicated by a minus sign.) X Answer is not complete. DIVE IN COMPANY Statement of Cash Flows For the Year Ended December 31 Cash Flows from Operating Activities: Cash Collected from Customers $ Cash Paid for Rent and Office Expenses Cash Paid for Salaries and Wages to Employees OOO (500) X 150 X (450) (800) Cash Flows Used in Investing Activities Cash Flows from Financing Activities Cash Proceeds from Issuing Stock > 200 Net Cash Provided by Financing Activities Net Decrease in Cash during the Year Cash Balance, January 1 Cash Balance December 31 OOOOO 200 (800) 4,000 3200 SO $ On each December 31, you plan to transfer $3,300 from your checking account into an investment account. The investment account will earn 5 percent annual interest, which will be added to the account balance at each year-end. The first deposit will be made December 31, 2021 (at the end of the period). (Future Value of $1, Present Value of $1, Future Value Annuity of $1, Present Value Annuity of $1, Financial Calculator) (Use tables, Excel, or a financial calculator.) Required: 1. What will be the balance in the account at the end of the 10th year (i.e., 10 deposits)? 2. What is the total amount of interest earned on the 10 deposits? 3. How much interest revenue did the fund earn in 2022 2023? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 What will be the balance in the account at the end of the 10th year (i.e., 10 deposits)? (Round "Future Value" to nearest whole dollar amount.) Table or Calculator Function: Annuity payments: n = % Future Value: On January 1, you plan to take a trip around the world upon graduation four years from now. Your grandmother wants to deposit sufficient funds for this trip in an investment account for you. On the basis of a budget, you estimate that the trip currently would cost $21,000. Being the generous and sweet lady she is, your grandmother decided to deposit $5,000 in the fund at the end of each of the next four years, starting on December 31, 2021. The account will earn 7 percent annual interest, which will be added to the account at each year-end. (Future Value of $1. Present Value of $1. Future Value Annuity of $1, Present Value Annuity of $1. Financial Calculator) (Use tables, Excel, or a financial calculator.) Required: 1. How much money will you have for the trip at the end of year 4 (i.e., after four deposits)? 2. What is the total amount of interest earned over the four years? 3. How much interest revenue did the fund earn in each of the four years, starting in 2021? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 How much money will you have for the trip at the end of year 4 (i.e., after four deposits)? (Round your final answer to the nearest whole dollar amount.) Balance in the Fund Your company plans to issue bonds later in the upcoming year. But with the economic uncertainty and varied interest rates, it is not clear how much money the company will receive when the bonds are issued. The company is committed to issuing 2,600 bonds, each of which will have a face value of $1,000, a stated interest rate of 8 percent paid annually, and a period to maturity of 10 years. You may use any approach (tables, Excel, or financial calculator app) to calculate the bond proceeds, if you use the tables, choose the appropriate factors from the following link(s): (Future Value of $1, Present Value of $1. Future Value Annuity of $1. Present Value Annuity. of $1, Financial Calculator) Required: 1. Compute the bond issue proceeds assuming a market interest rate of 8 percent. Also, express the bond issue price as a percentage by comparing the total proceeds to the total face value. 2. Compute the bond issue proceeds assuming a market interest rate of 7 percent. Also, express the bond issue price as a percentage by comparing the total proceeds to the total face value. 3. Compute the bond issue proceeds assuming a market interest rate of 9 percent. Also, express the bond issue price as a percentage by comparing the total proceeds to the total face value. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Compute the bond issue proceeds assuming a market interest rate of 8 percent. Also, express the bond issue price as a percentage by comparing the total proceeds to the total face value. (Round "Bond Issue Price as a Percentage" to 2 decimal places.) Present value of total proceeds from bond issue Bond Issue Price as a Percentage of Face Value %