Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

What is the correct PV excel formula for F14? I know the answer is $7,282,977 but it's telling me my answer is incorrect due to

What is the correct PV excel formula for F14?

I know the answer is $7,282,977 but it's telling me my answer is incorrect due to an incorrect formula.

Thank you!

image text in transcribed

\begin{tabular}{|c|l|c|} \hline 7 & Bonds dated & Principal \\ \hline 8 & Stated rate & Market (effective) rate \\ \hline 9 & Term (years) \\ \hline 10 & Interest payments per year \\ \hline 11 & & $,2023,000,000 \\ \hline 12 & & 20.5% \\ \hline 13 & & 11.0% \\ \hline \end{tabular} 1. Determine the price of the bonds at January 1, 2023 using Excel's PV function. =PV(E10/2,E11E12,E8E9/2,E8) Formula m 3. Record the first interest payment on June 30,2023 (at the effective rate). \begin{tabular}{|c|c|r|r|} \hline 23 & \multicolumn{1}{|c|}{ Date } & \multicolumn{2}{|c|}{ Credit } \\ \hline 24 & June 30, 2023 & Interest expense & \\ \hline 25 & & Cash & \\ \hline 26 & & Discount on bonds payable & \\ \hline \end{tabular} 4. Record the second interest payment on December 31, 2023 (at the effective rate). \begin{tabular}{|l|c|c|c|r|} \hline 29 & \multicolumn{1}{c|}{ Date } & \multicolumn{1}{c|}{ General Journal } & \multicolumn{1}{c|}{ Debit } \\ \hline 30 & December 31, 2023 & Interest expense & 401,695 & \\ \hline 31 & & Cash & \\ \hline 32 & & Discount on bonds payable & 380,000 \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Audit Committee Handbook

Authors: Louis Braiotta Jr.

4th Edition

0470226420, 978-0470226421

More Books

Students also viewed these Accounting questions

Question

Name four types of information that are found on networks.

Answered: 1 week ago

Question

What are the purposes of collection messages? (Objective 5)

Answered: 1 week ago