CNBC reported that one in five consumers who purchase bitcoin do so using their credit card....

   

Transcribed Image Text:

CNBC reported that one in five consumers who purchase bitcoin do so using their credit card. Melissa Gamez purchased a used RV with 19,000 miles for $46,900. Originally the RV sold for $70,000 with a residual value of $20,000. After subtracting the residual value, depreciation allowance per mile was $0.86. Used RV miles Used RV price Original RV price Original RV residual value Depreciation allowance per mile Required: Use the above information to answer the following: 19,000 $46,900 $70,000 $20,000 $0.86 Note: Use cells A4 to B8 from the given information to complete the question. 11 Use the above information to answer the following: 12 13 Note: Use cells A4 to B8 from the given information to complete this question. 14 15 1. What is the book value of the RV being purchased? 16 17 2. How much was Melissa's purchase price over or below the book value? 3. Does she have any equity that might assist her with purchasing bitcoin? Yes, she has equity 18 19 No, she doesn't have equity 20 21 ete this question. book + asing Formula must return a POSITVE value if purchase price is over book value and a NEGATIVE value if purchase price is below book value. omplete this question. w the book Ourchasing + Formula may only include cell references (no values). CNBC reported that one in five consumers who purchase bitcoin do so using their credit card. Melissa Gamez purchased a used RV with 19,000 miles for $46,900. Originally the RV sold for $70,000 with a residual value of $20,000. After subtracting the residual value, depreciation allowance per mile was $0.86. Used RV miles Used RV price Original RV price Original RV residual value Depreciation allowance per mile Required: Use the above information to answer the following: 19,000 $46,900 $70,000 $20,000 $0.86 Note: Use cells A4 to B8 from the given information to complete the question. 11 Use the above information to answer the following: 12 13 Note: Use cells A4 to B8 from the given information to complete this question. 14 15 1. What is the book value of the RV being purchased? 16 17 2. How much was Melissa's purchase price over or below the book value? 3. Does she have any equity that might assist her with purchasing bitcoin? Yes, she has equity 18 19 No, she doesn't have equity 20 21 ete this question. book + asing Formula must return a POSITVE value if purchase price is over book value and a NEGATIVE value if purchase price is below book value. omplete this question. w the book Ourchasing + Formula may only include cell references (no values).