ZuoTi.Pro
Question

Please show the steps

BoyuQuCh7CaseStudy - Excel File Insert Page Layout Formulas Data Review View Add-ins ACROBAT QuickBooks Tell me what you want to do Sign in Share Σ Autosum Calibri Fill Paste в ㅣ u . re. O . . _ Ξ_ 트트 분 Merge & Center. $. % , i..g Conditional Format as Cell Insert Delete Format Sort & Find & Filter Select Formatting Table Styles Clipboard Font Alignment Number Cells Editing E3 Input Area Calculations 2 Facility Costs $ 720,000.00 3 Down Payment $250,000.00 12 Loan Amount No. Periods Monthly Rate Monthly Payment Total Interest Paid 470,000.00 4 # of Pmts per Year 5 Years 6 APR 5.25% Beginning Balance Ending Balance Interest Principal 10 nt # 12 13 14 15 16 17 18 19 21 23 25 28 29 30 31 32 34 cquisition Ready 囲 回凹 100% 3:14 PM Type here to search ^ 4) ENG 2019-01-23222222 pdf-Adobe Acrobat Pro DC File Edit View Window Help Home Tools Document Q 1/2 For the purpose of grading the project you are required to perform the following tasks: Points Step Instructions Open Ch7CaseStudy.xlsx file and save as LastNameFirstNameCh7CaseStudy.xlsx. In cell E3, enter a formula to calculate the Number of Periods referencing the applicable cells in the Input Area. In cell E4, enter a formula to calculate the monthly interest rate referencing the applicable 3 cells in the Input Area. Format the result as Percent and 2 decimal places. In cell E5, use a function to calculate the monthly payment referencing the applicable cells in the Summary Calculations area. Show the result as a positive number In the Payment # column, enter in values for 5 payments. Note: Be sure to complete the column only through row 15. In cell B11 enter the correct reference to the beginning balance In the Interest Paid and Principal Payment columns, use financial functions to calculate the Interest Paid and Principal Payment for the first payment. Show all results as positive 10 In cell E11, enter a formula that will calculate the Ending Balance for the first payment. 8 In cell B12 enter the correct cell reference that retrieves the Ending Balance (after payment Complete the rest of the table by copying down the formulas. (Hint: be careful when copying the formula down the Beginning Balance column that you choose the correct cell to copy 10 down. Depending on the column you copy down first, you may see zeros as results until the other columns are copied.) 3:15 PM Type here to search ^ 4) ENG 2019-01-23222222 pdf-Adobe Acrobat Pro DC File Edit View Window Help Home Tools Document Q 2 /2 Points Step Instructions In cell E6, enter a function that will calculate the cumulative interest paid after five payments. for the start and end period arguments. Leave the result as a negative number Format all monetary values in the table and the summary calculations area as Accounting 11 Reference the loan information in E2:E4 and the corresponding Payment number in the table 12 format to 2 decimal places. Save and close the file. Upload the closed file to the XLCh7 Case Study link in Myitlab. 13 0 Total Points 32 3:15 PM Type here to search ^ 4) ENG 2019-01-23

business   accounting   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Input Area Summary Calculations Facility Costs Down-payment # of pmts per year Years APR 720000 250000 12 30 5.25% Loan Amount No. of Periods Monthly Rate Monthly payment Total Interest Paid 470000 360 0.44% $2,595.36 464328.664 4 6 9 Beginning Balance Ending balance Principal Payment $539.11 $541.47 543.83 $546.21 548.60 Payment # 10 Paid 12 13 14 15 16 17 18 470000 $2,056.25 2 $469,460.89 $2,053.89 3 $468,919.43 $2,051.52 4 468375.5917 $2,049.14 5 467829.3775 $2,046.75 $469,460.89 $468,919.43 $468,375.59 $467,829.38 $467,280.77Inbut Area Summary Calculstions Loa An ount $470,006 Faaltycost 12,000 Afo . of periods By XBS ,3 Douapaymot25D, 0o O DoLon 3 o cars tolal Interest paid (. xE) E 5、251. 丹PR 2,S1S.3G R. eginning Lnteretprinip peiumer to Payment tBalanys Bal anee 470,000 Att, E3, 2

0 0
Add a comment
Know the answer?
Add Answer to:
Please show the steps BoyuQuCh7CaseStudy - Excel File Insert Page Layout Formulas Data Review View Add-ins...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Bond Pricing Excel FILE HOME INSERT PAGE LAYOUT FORMULAS Sign In DATA REVIEW MEW Calibri 11...

    Bond Pricing Excel FILE HOME INSERT PAGE LAYOUT FORMULAS Sign In DATA REVIEW MEW Calibri 11 A A Paste Conditional Format as Formatting Table Styles Styles Alignment Number Cell I U Cells Editing Clipboard Font H11 H E G 1 On January 1, Ruiz Company issued bonds as follows: 2 Face Value: 3 Number of Years: 4 Stated Interest Rate: 5 interest payments per year 6 (Note: the bonds pay interest semi-annually.) 500,000 30 7 % 2 8 Required: 9...

  • Chapter 10 Excel Assignm AutoSave OFF Formulas Data Review View Page Layout Draw Home Insert A...

    Chapter 10 Excel Assignm AutoSave OFF Formulas Data Review View Page Layout Draw Home Insert A A General 10 Arial A $.% 9 0 BIU Paste fx 047 D E C B A Name: ACC 213 Lab #9 for Chapter 10-Installment Notes & Amortization Tables 3 Instructions: First, complete the amortization table in Part 1 using the information provided. 4 Once the table is completed, then record the two joumal entries in Part 2. 5 Information: 6 Your car loan...

  • PLE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW ADD-INS QuickBooks 614 X f r --PMT(4010/12,011*09,08)...

    PLE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW ADD-INS QuickBooks 614 X f r --PMT(4010/12,011*09,08) HT Name: kelly gamer Your score On January 1, 2020 the Kelly Gamer Company borrows $150,000 cash by signing a 5-year, 10%, installment note, with semiannual interest payments. 1) Calculate the amount of each payment using the PMT function. 2) Prepare the amortization schedule for the loan. Enter a valid Excel formula or function in each of the yellow cells below. Formulas must refer...

  • This worksheet will compute the monthly value of an amortized loan for 36 months. This will...

    This worksheet will compute the monthly value of an amortized loan for 36 months. This will be a worksheet in which the loan value or principal, interest rate, and monthly payment can be changed and the worksheet will automatically update. Within the worksheet there will be some absolute cell referencing that is needed and some relative cell referencing that is needed. You will need to determine which is appropriate. Title the worksheet "Amortization of Car Loan" in cell A1. Leave...

  • Week 5 Homework Assignment-Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri - 11...

    Week 5 Homework Assignment-Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri - 11 A A Wrap Text Auto Fil- General Paste BIU - A Merge & Center E Conditional Format as Cell Formatting Insert Delete Formar Clear- Table Styles Clipboard Font Alignment Number Styles Cells K11 A D F G H J 1 Comprehensive Budgeting Problem 20 points Silverman Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain...

  • Using the DuPont identity- Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In...

    Using the DuPont identity- Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Arial 12A A Paste - A Alignment Number Conditional Format as Cell Cells Formatting TableStyles- Clipboard Font Styles D13 Zombie Corp. has a profit margin of 5.1 percent, total asset turnover of 1.95, and ROE of 16.15 percent. What is this firm's debt-equity ratio? Profit margin Total asset turnover Return on equity 5.10% 1.95 16.15% 10 Complete the following analysis. Do not hard code...

  • XS FILE HOME Relationships among Financial Statements - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW INSERT...

    XS FILE HOME Relationships among Financial Statements - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW INSERT Sign In fc Calculate Now Calculation RC Function Defined Formula Library Names' Auditing Calculation Presented below are incomplete financial statements for Marta Communications, B 1 Presented below are incomplete financial statements for Marta Communications, Inc. 3 Required: 4 Solve for the missing amounts. NOTE: When an amount on one financial statement is again shown on 5 another statement, you MUST reference the cell from...

  • X! Preparing a classified balance sheet - Excel х FILE HOME INSERT PAGE LAYOUT FORMULAS DATA...

    X! Preparing a classified balance sheet - Excel х FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri 11 Α Α΄ % Paste BIU- Alignment Number Cells Conditional Format as Cell Formatting Table Styles Styles Clipboard Font 1 : A B с I 37 38 D E F G H LANTANA COMPANY Balance Sheet At December 31, 2016 Liabilities and Stockholders' Equity Current Liabilities 39 40 Assets 41 Current Assets 42 Total Current Liabilities 43 44 Total...

  • Formulas - Setup the worksheet with formulas! 1. Open the MT Data file and save it...

    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:...

  • XES FILE HOME Calculating dividend yield and capital gains yield - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW INSERT S...

    XES FILE HOME Calculating dividend yield and capital gains yield - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW INSERT Sign In % Arial - - 12 - A A Paste B IU B A Editing Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells - Clipboard Font D15 AB DE F G H The next dividend payment by Halestorm, Inc., will be $2.04 per share. The dividends are anticipated to maintain a growth rate of 4.5 percent forever....

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT