Practica Exam #1

1 Start with a Blank Excel Workbook           2 Your data will consist of the information provided below         3 Determine the Monthly Payment using the "PMT" formula       4 Create a detailed amortization schedule for the number of months below     5 Amortization schedule must include Interest calculation and a running balance     6 Create a Payment Dates Balance Lookup that uses the VLOOKUP formula to return the Balance for a given date 7 Extra credit (Use a Drop-Down list to select the Look up Date using "Payment Date" from your amortization scheduled 8 Format your document to only print the summary information without the amortization schedule (print on 1 page)                   Purchase Amount:    $  29,000.00             Down Payment Amount    $    1,000.00             YourName Loan Amount    $  28,000.00     (Summary Information)     Term (months):   36             Interest Rate (APR):   3.50%             Starting Date   12/7/2021…

help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working

Please help me answer parts D and F ONLY. Thank you!

Use the present value and future value tables to answer the following questions. Time Value of Money - Principles of Accounting, Volume 2: Managerial Accounting | OpenStax A. If you would like to accumulate $2,400 over the next 5 years when the interest rate is 15%, how much do you need to deposit in the account? $_____ B. If you place $6,200 in a savings account, how much will you have at the end of 6 years with a 12% interest rate? $_____ C. You invest $7,000 per year for 11 years at 12% interest, how much will you have at the end of 11 years? $_____ D. You win the lottery and can either receive $760,000 as a lump sum or $60,000 per year for 19 years. Assuming you can earn 8% interest, which do you recommend and why? _____

Solar Solutions began operations on January 1, 2015, and is now in its sixth year of operations. It is a retail sales company with a large amount of online sales. The adjusted trial balance as of December 31, 2020 appears below, along with prior year balance sheet data and some additional transaction data for 2020. SOLAR SOLUTIONS Adjusted Trial Balance 12/31/2020 2020 2019 Account Title Adjusted Trial Balance Post-Closing Trial Balance Debit Credit Debit Credit Cash $ 122,200 55,000 125,600 Accounts Receivable 35,000 Prepaid Insurance 5,000 6,000 |Inventory Office Equipment Machinery & Tools Accumulated Depreciation Accounts Payable Salaries Payable Sales Tax Payable Note Payable-Long Term Common Stock, $10 par 46,000 15,600 63,000 47,000 59,000 21,000 21,000 16,000 11,200 16,800 2,600 2,700 2,000 4,000 31,000 22,100 240,000 160,000 Retained Earnings 28,600 28,600 Dividends 10,000 Sales Revenue Cost of Goods Sold Rent Expense Salaries Expense 235,000 127,600 20,000 36,000 Insurance…

help  please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working

help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working

Common-Size Financial Statement Analysis Using Excel Completing this activity will help you learn to: 1. create Excel formulas using cell references. 2. create absolute cell references to perform calculations efficiently and correctly. 3. apply conditional formatting to highlight cells based on criteria that you specify. Case scenario: You are working at a small business that has been mostly stable. You want to analyze the financial statements of the past five years to examine the trends over time and compare the percentages of income statement items relative to overall sales. You also want to highlight cells according to whether the calculated ratio increases or decreases more than a specified amount. Required: Download spreadsheet CommonSizeCaseData-52d586.xlsx You will build a spreadsheet that performs common-size analysis using five years of a company's income statements. Specifically, you will create two sheets within the workbook, one for the horizontal analysis and one for the…

Can I know how to solve this?

Please Write Step by Step Answer Otherwise i give DISLIKE !!

help  please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working

Question 2  Sketch a graph that represents the following situation. Be sure to label the graph appropriately. A student with an internship for the summer borrowed money from his mom to purchase a new phone for $1200. The graph shows the amount the student owes his mom as he makes $100 payments once a week for 5 weeks.

Please help me create a balance sheet and an income statement for the year following exhibits 1.2 and 1.3

Excel Skills 7. Solve the follow sections: a. Complete the following spreadsheet, showing how much will be in your bank account if you deposit an initial deposit (cell B2) today and it draws annual interest given in cell B1. Interest 2 Initial deposit 3 4 5 6 7 A 8 9 10 Year " 0 1 23 4 5 B b. Graph the results of the bank account. 8% $155 In bank account.

TIME VALUE OF MONEY ANALYSIS You have applied for a job with a local bank. As part of its evaluation process, you must take an examination on time value of money analysis covering the following questions: a. Draw time lines for (1) a $100 lump sum cash flow at the end of Year 2:01an ordinary annuity of $100 per year for 3 years; and (3) an uneven cas Graphical user interface, text, application $50 at the end of Years 0 through 3. b. (1) What's the future value of $ al compounding? (2) What's the prosent value of $ Description automatically generated strate is 10%, annual compounding? C. d. e. What annual interest rate would cause $100 to grow to $125.97 in 3 years? If a company's sales are growing at a rate of 20% annually, how long will it take sales to double? What's the difference between an ordinary annuity and an annuity due? What type of annuity is shown here? How would you change it to the other type of annuity? 1 0 ㅏ 2 + $100 0 3 1 $100 $100 f. (1) What is the future value of a…

Part 1: Data Tables You have decided to start saving for retirement. You plan to work for 35 years and then retire. Requirements: Complete each requirement on a separate worksheet. 1. Calculate the amount of money that will be in your Roth IRA account when you retire if you: a. Save $3,500 at the end of each year. b. Earn 7% interest each year. c. The answer to requirement I must be calculated using a single formula. 2. Create a one-input Data Table that calculates the value of your Roth IRA when you retire if the annual savings amount is different than $3,500 per year. a. Use the following annual end of the year annual savings amounts as the column data in the Data Table: $500, $1,000, $2,000, $3,000, $3,500, $4,000, and $5,000. b. The annual interest rate is still 7% each year. 3. Create a two-input Data Table that calculates the value of your Roth IRA when you retire for different annual interest rates and different annual savings amounts. a. Use the following annual interest rates…

Excel Online Structured Activity: Amortization schedule The data on a loan has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. X Open spreadsheet a. Complete an amortization schedule for a $42,000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate is 9% compounded annually. Round all answers to the nearest cent. Year 1 2 3 Year 1: Year 2: Year 3: I $ $ $ Beginning Balance ||| IV V % Interest % heck My Work $ $ % Payment b. What percentage of the payment represents interest and what percentage represents principal for each of the three years? Round all answers to two decimal places. % Principal % Reset Problem % $ $ $ % Interest $ $ $ Repayment of Principal $ c. Why do these percentages change over time? I. These percentages change over time because even though the total payment is constant the amount of interest paid each year is declining as…

Step Instruction 20 The location managers want new company cars. The chief financial officer has determined that the company can afford $600 monthly payments based on a 5.25% APR for three-year loans. Your first step is to calculate the loan. Display the 3-Finance worksheet. In cell E2, insert the PV function using the periodic rate, the number of payment periods, and a negative value for the monthly payment.

Subject: accounting