HSA 4170 health and financial
Instructions 1 Follow general direction in Canvas. (How submit, Zoom video, etc) Join the class via Zoom. Zoom Meeting ID: 838 2915 5326. Password: ABCsleep Video must be on for entire exam. Grade is zero if video not on for entire exam Zoom name must match your name. 2 File must be saved as LastName.xlsx (IE-Smith.xlsx). 3 All work must be done in Excel. (XLSX file format. No other format allowed.) 4 Do computations directly under the blue-shated question. Use Excel formula to get answer. Do not simply type in the answer. For example, A cell with ‘95.15’ receives zero; A cell with [=-PV(0.01,5,,100)] gets c Yellow-Highlight cells with final answer. 5 q1 You can add more blank lines between questions if needed. Do not write in blue-shaded area. Question text can not be copied, so you will have to re-enter numbers. In 2024, Medicare has the following rules: Part B: Deductible $240 per year. 20% Copay. Prior to a physician visit, the patient has already spent $90 toward part B deductible. The allowed charge for the physician visit is: $300. What is the total out-of-pocket spending by the patient? How much of that total is to fulfill their deductible? How much of that total is to cover their copay? (Report all three amounts to the penny.) q2 You are considering two cars for your sales representatives. To minimize costs, choose the car with the lowest total present value. Discount rate per month is 0.20%. (Careful. In decimal terms: 0.0020.) ‘Due at signing’ is paid once, at the beginning & counts toward total cost. What is the total present value of Car A? What is the total present value of Car B? (Show calculations. Report to cents. IE $123.12) Car A Car B Due at signing 500 1,000 Amount due each month 275 375 Number of months 36 36 q3 You have a loan with the following terms: Principle 300,000.00 Interest rate 0.02 Number of periods 3.00 Payment per period 104,026.40 Create an amortization table that looks like this: (Show computations. Show dollars and cents.) Year 1 Beginning amount Payment Interest Repayment of principle Remaining principle balance Year 2 Year q4 You buy a delivery van for $60000. It depreciates $20000 in year 1, $15000 in year 2, and $7000 in year 3, At the end of the third year, you sell it for $15000. What is your capital gain or loss? You buy a delivery van for $60000. It depreciates $20000 in year 1, $15000 in year 2, and $7000 in year 3, At the end of the third year, you sell it for $15000. What is your capital gain or loss? (Assume 0% tax rate. Show computations.). END OF EXAM _ _ _ _ _ m video, etc) sword: ABCsleep exam . other format allowed.) on. n the answer. ith [=-PV(0.01,5,,100)] gets credit. eded. -enter numbers. t? atives. al present value. mal terms: 0.0020.) ts toward total cost. A 0 5 6 Car B 1,000 375 36 Year 2 Year 3 and $7000 in year 3, and $7000 in year 3, _ _
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.