Hello, I need some help with some Excel formulas.
a. Open Excel_Ch11HW.xlsx and save it as
Excel_Ch11HW_LastNameFirstName.
b. Click cell H4, the cell containing the ending date for the first
loan. Enter the formula to compute the ending date, based on the
starting date and the term of the loan. For the sake of simplicity,
you don’t have to account for leap year. To compute the ending
date, multiply the term of the loan by 365 and add that result to
the starting date. Be sure to format the starting and ending dates
to show a date format and widen columns as necessary.
c. Click cell I4 and enter the PMT function to compute the monthly
payment for the first loan. Copy the formulas in cells H4 and I4 to
the remaining rows in the worksheet.
d. Name your database range Loan_Database (A3 through I26) and name
your criteria range Loan_Criteria (A28 through I29).
e. Enter the indicated criteria in cell D29. Then enter the
indicated database functions into cells C32, C33, C34, H32, H33,
and H34. Use the Advanced Filter command to filter the list,
in-place (use Loan_Database as your list range and Loan_Criteria as
your criteria range) to display only those loans that satisfy the
indicated criteria as shown in the Figure below. Format the list as
closely as possible to the image in the Figure.
f. Look closely at the bottom of the Figure and note the
presence of a PivotTable worksheet. Create a PivotTable that has
the loan type and branch in the row and column fields,
respectively. Your PivotTable is to contain two data fields, the
total amount of the loans and the average interest rate. Format the
PivotTable report fields as currency with 0 decimals and percentage
with 2 decimals. Add Summary Loan Statistics as the title of the
report. Rename the Sheet1 tab as PivotTable.
g. Create a custom footer containing your name in the left section,
the name of the worksheet in the center section, and today’s date
in the right section. Be sure to print gridlines and row and column
headings, making sure the Loans worksheet and the PivotTable would
each print on one page. Save your workbook and upload it to
Canvas.
b) use the below formula to calculate end date
IF(G9,G9+(F9*365),"")
G9-start date
F9-terms
c) PMT(rate,periods,-amount)
Hello, I need some help with some Excel formulas. a. Open Excel_Ch11HW.xlsx and save it as...
Formulas - Setup the worksheet with formulas! 1. Open the MT Data file and save it as MT School Budget. Select the Budget sheet if it's not already showing on your screen. 2. In D11, calculate the Fall Term Total by adding the One-Time amount (B11) to the Monthly amount (C11) multiplied by the Months in the Term (B5). Make sure to use an absolute reference in the formula so that it will copy correctly in the next step. Note:...
All answers must be entererd as formulas CHAPTER 5 Saved Help Save & Exit Submit Paste B I U. . Font Editing . A . Alignment Number Conditional Format as Cell - Formatting Table Styles Styles Cells . Clipboard 5 Prepare an amortization schedule for a five-year loan of $67,500. The interest rate is 7 percent per year, and the loan calls for equal annual payments. How much total interest is paid over the life of the loan? Loan amount...
please post with pictures of step by step solution oject Description: u own five apartment complexes. You created a dataset listing the apartment numbers, apartment complex mes, as last remodeled. You want artments need to number of bedrooms, rental price, whether the apartment is occupied or not, and the date the apartment to insert some functions to perform calculations to help you decide which be remodeled. To focus on the apartments that need to be remodeled, you will use vanced...
Could anyone help me with the lookup function for #5? Plain Text Tahoma Start Excel. Open the file named ex02TravelAgency START Save the file with the name 0.000 ex02TravelAgency LastFirst, replacing LastFirst with your name. On the Agency Clients worksheet, apply the Table Style Light 14 to the Clients named range. Note, the style may be named Green, Table Style Light 14, depending on the version of Office used. 2 2.000 3 named ranges for each of the column headings...
5. Kaleen now wishes to finalize the Amortization schedule. In cell J4, create a formula without using a function that subtracts the value in cell I4 from the value in cell H4 to determine how much of the mortgage principal is being paid off each year. Copy the formula in cell J4 to the range J5:J18. I cant figure out the formula can someone help? britt ct BE - Comments AutoSave C H 2 File Home Insert X Cut Paste...
i need help forming the journal entries for the information above. Data Tools window Help Format Edit View Insert Excel file Data Formulas Review View Home Insert Page Layout f income taxes are to be computed at the rate of 25 percent of net in 8.81 Byte of Accounting, Inc. 597.750 inch and with a first of Jet Byte of A gined 2365 ha ofisc herg Courney 541.250 in cash computer with a market of 514 S o ffice een...
Hello, I need help with the journal entries for transactions 29, 34, 35, 37, and 38. 01. June 1: Byte issued 2,660 shares of common stock to Lisa after $28,600 in cash and computer equip with a fair market value of $40,560 were received. 02. June 1: Byte issued 2,282 of it's common stock after acquiring from Andrew $48,100 in cash, computer equipment with a FMV of $10,920 and office equip with a FMV of $676 03. June 1: Byte...
Ive done all the previous statements. I need help on how to do the post-closing trial balance for this question. I've already done the previous statements. Scenario: Moonlight Bay Inn is incorporated on January 2, 2017, by its three owners, each of whom contributes $20,000 in cash in exchange for shares of stock in the business. In addition to the sale of stock, the following transactions are entered into during the month of January: Requirement #10: Prepare a post-closing trial...
can someone help with the blue reader project, please? I have the journal entries I need help with journal ledger and trial balance so I can I do the financial statements. thanks can someone help me the ledger and trial balance please, I posted all the information about the picture Credit The accounting cycle illustrated below is designed to provide information about a company's profitability for lack thereof) along with many other important financial characteristics. This same accounting Cycle is...
I need help with step 5,6,7, please ? 15%60-900 Page 2 GENERAL JOURNAL Tagolt golo HOL cash tickets Revende 1660 1652 Account Payable Cash 90 Account necunibe Ticket nevenue 13 nowing expense 23 са 1345 Cash account nechua Sep 25 wages expen cash m. Lapinski withclantas cash 15X60 900 GENERAL JOURNAL Vol REL9900 cash tickets nevenue Sep 1650 Account Payable cash 1652 AFFA Account necenible Ticket nevenue Sep 18 nowing eyrense 26 now ticket new ep 24 T cash account...