A B

$C$

D

E

G

H

I

Accounting and the Time Value of Money

Expected Cash Flows needed to cover the notes outstanding over the next four years. Estimated lost cash flows and the probability of occurrence four years are summarized in the following schedule.

Risk$-$free rate

$8\%$

Use the blue shaded areas on the ENTERANSWERS tab for inputs.

Always use cell references and formulas where appropriate to receive full credit. If you copy$/$paste from the Instruction ta wrong.

Requirement

What is the estimated bad debt allowance at December $31,2022?$

Saving & Submitting Solution

$1$ Save file to desktop.

a$.$ Create folder on desktop, and label COMPLETED EXCEL PROJECTS

INSTRUCTIONS