Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

What are the formulas to put in, this question has already been answered but it is wrong. A) Create an amortization table for a business

image text in transcribedimage text in transcribedimage text in transcribedWhat are the formulas to put in, this question has already been answered but it is wrong.

A) Create an amortization table for a business with the following information. Loan: $5,000,000 Annual interest rate: 2.9% Loan period: 10 years Payments: monthly, end of each month Loan will be fully paid in 10 years. Assignment 9 - Data B) Create a table to show cumulative interest payments and cumulative principal payments of this loan for each year. C) Build a cash flow table for a service business using the loan information from parts "A" and "B". Calculate net cash flow for duration of the projects. Additional information is as follows: - Facility lifetime: 10 years - Investment on the facility and equipment: $5,000,000 - Salvage value: $1,000,000 - Annual revenue: $650,000 first year, 10% increase for year 2 , and 20% annual increase after that - Annual operating costs: - Insurance: $13,000 - Maintenance and utility: $18,000 - Wages: $240,000 - Income tax rate: 20\%. This business does not pay any tax when there is a loss. There is no tax credit for the future. im +

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Accounting questions