FAR Excel Problems

Thomas & Co issued $1,000,000 in bonds and receives proceeds of $1,085,302. The stated rate on the bond is 8%. The effective rate is 6%. The bond was issued on January 1st year 1 and have a 5 year maturity. Interest is paid semiannually on June 30 and December 31.

1. Create a table straight method

2. JE for Bond Issuance, Interest payment and maturity

Bond Issued @premium-Straight

Thomas & Co issued $1,000,000 in bonds and receives proceeds of $957,350. The stated rate on the bond is 5%. The effective rate is 6%. The bond was issued on January 1st year 1 and have a 5 year maturity. Interest is paid semiannually on June 30 and December 31.

1. Create a table for the straight method

2. JE for Bond Issuance, Interest payment and maturity

Bond Issued @discount-Straight

Thomas & Co issued $1,000,000 in bonds and receives proceeds of $1,085,302. The stated rate on the bond is 8%. The effective rate is 6%. The bond was issued on January 1st year 1 and have a 5 year maturity. Interest is paid semiannually on June 30 and December 31.

1. Create a table for effective method

2. JE for Bond Issuance, Interest payment and maturity

Bond Issued @premium- Effective

Bond @premium- Find Proceed

Thomas & Co issued $1,000,000 in bonds and receives proceeds of $957,350. The stated rate on the bond is 5%. The effective rate is 6%. The bond was issued on January 1st year 1 and have a 5 year maturity. Interest is paid semiannually on June 30 and December 31.

1. Create a table for the straight method

2. JE for Bond Issuance, Interest payment and maturity

Bond Issued @discoun- Effective

Bond with issuance cost

Without CV Bond

Create a table and JE for all 3 years

Finance Lease

Create a table and JE for all 3 years

Operating Lease