Construct a data table in excel that will show lindsay the balance of her retirement account for various levels of annual investment and return. if lindsay invests $11,000 at return of 6%, what would be the balance at the end of 20th year in the account

On january 1, 2018, red flash photography had the following balances: cash, $19,000; supplies, $8,700; land, $67,000; deferred revenue, $5,700; common stock $57,000; and retained earnings, $32,000. during 2018, the company had the following transactions: 1. february 15 issue additional shares of common stock, $27,000. 2. may 20 provide services to customers for cash, $42,000, and on account, $37,000. 3. august 31 pay salaries to employees for work in 2018, $30,000. 4. october 1 purchase rental space for one year, $19,000. 5. november 17 purchase supplies on account, $29,000. 6. december 30 pay dividends, $2,700. the following information is available on december 31, 2018: 1. employees are owed an additional $4,700 in salaries. 2. three months of the rental space has expired. 3. supplies of $5,700 remain on hand. 4. all of the services associated with the beginning deferred revenue have been performed.required: 1. record the transactions that occurred during the year.2. record the adjusting entries at the end of the year.3. prepare an adjusted trial balance.4. prepare an income statement, statement of stockholders’ equity, and classified balance sheet.5. prepare closing entries.

What are the forecasted levels of the line of credit and special dividends? (hints: create a column showing the ratios for the current year; then create a new column showing the ratios used in the forecast. also, create a preliminary forecast that doesn’t include any new line of credit or special dividends. identify the financing deficit or surplus in this preliminary forecast and then add a new column that shows the final forecast that includes any new line of credit or special dividend.) now assume that the growth in sales is only 3%. what are the forecasted levels of the line of credit and special dividends?

You hold a diversified $100,000 portfolio consisting of 20 stocks with $5,000 invested in each. the portfolio's beta is 1.12. you plan to sell a stock with b = 0.90 and use the proceeds to buy a new stock with b = 1.50. what will the portfolio's new beta be? do not round your intermediate calculations.