Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. 44. please refer to the following screenshot. tim

44. Please refer to the following screenshot. Tim is interested in taking a loan for...

70.2K

Verified Solution

Question

Accounting

image
image
image
44. Please refer to the following screenshot. Tim is interested in taking a loan for a home Improvement project. He is setting the amount and the time period of the loan so that the monthly payment is less than $2000. To see the payment amounts with different options, Tim set up a two-way table as shown in the screenshot. What should Tim enter in Cell D12 C 0 F 180000 G 185000 175000 190000 195000 200000 6 1 Loan Amount 200000 2 Interest Rate 3 Number of Payments 60 4 Payment Amount $266,56 5 6 7 72 84 96 108 120 132 144 156 168 180 10 OOO PMT(B2,$B$3,$B$1) =PMT(B2/12,B3, E1) -B4 -B1 45. Please refer to the following screenshot. Claire has entered the numbers, putting 5 digits after the decimal. Now she wants to show only two digits after the decimal. The only way to achieve this goal is to manually delete the three unwanted digits of each number. 1 2. 3 4 5 6 7 8 A 12.32464 43.46413 98.45464 76.45431 32.79879 67.78943 78.46587 96.12379 True False 46. Instead of using the default formats for dates in Excel, one can create one's own custom formats. True False

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students