A Spreadsheet Reversed His $58,000 Boat Loan Rejection

The spreadsheet covered one year. Twelve columns ran across the page, with deposits near the top and boat expenses below. The last line showed $112,600 in gross fishing income.

Martin, the fisherman in this composite story, printed the sheet after his equipment loan application was declined. He had applied for $58,000 to replace the engine in his commercial fishing boat, a job estimated at $72,500. He planned to put in $14,500 from savings.

The engine still ran, but metal had appeared in the oil. A mechanic told him that another failure could damage parts that were not included in the estimate. Martin had already lost nine working days to small repairs during the previous season, and each trip now began with a decision about whether the engine sounded different or whether he had grown used to listening for trouble.

His loan notice referred to cash-flow concerns and unstable revenue. It did not say that his annual income was too low. Martin's tax returns showed that the business had earned enough to cover the proposed payment in each of the previous two years.

The problem appeared to be the shape of the latest year.

A year flattened into 12 boxes

Commercial fishing income does not arrive like a paycheck. Martin might make three landings in a strong month, then leave the boat tied up while a fishing area was closed or the weather kept smaller vessels in port. A buyer paid him after each landing. Fuel, ice and repairs were due whether the next trip produced a full hold or a short one.

The year on the spreadsheet had been unusual even by that standard. A seasonal opening came six weeks later than Martin had expected, and rough conditions reduced the number of trips he could make near the start. His deposits remained below $2,000 in four months. Later, after the opening and a run of workable weather, one month brought in $46,700.

Annual revenue had fallen by $6,800 from his two-year average. Martin understood that decline. What he did not understand was why the application treated four quiet months as evidence that the business itself was failing, when those months included the delayed opening and the period he normally used for maintenance.

The printed spreadsheet sat on his kitchen table beside the engine estimate. Its numbers were accurate. Their order was accurate too. Yet the page showed a sequence that made more sense to someone who knew when the boat could fish, what it could catch and when buyers were taking that catch.

The lender had asked for bank statements and tax records. Its software sorted deposits and withdrawals, calculated monthly averages, and looked for patterns associated with the ability to make payments. Martin was later told that the initial review relied heavily on recent monthly cash flow. Large swings counted against the application, even though the total deposits were close to his prior years.

A transfer from his business savings also complicated the picture. He had moved $8,000 into checking to pay a boatyard bill. On the account record, the transfer appeared among ordinary deposits. The software did not understand that the money was neither catch revenue nor a new loan.

It was money the business had already earned.

Martin had kept enough cash available to absorb the late season. That reserve did not make the income look steadier. In one respect, it made the bank record harder to read.

The appeal needed a fishing calendar

Martin contacted the lender through the number on the account page and asked for a review. He did not argue that the deposits were regular. They were not. He argued that monthly regularity was the wrong measure for this business.

The appeal required documents he already had, but not in the categories the lender had used. His fishing log recorded trip dates and pounds landed. Settlement slips from the buyer showed what each landing brought in. The bank statements showed when the money arrived.

None of those records, on its own, explained why a low month could be normal or why a high month might cover expenses that continued through the next closure.

He returned to the spreadsheet.

Martin added a row for fishing days and another for days when the boat could not work because of the delayed opening or weather. He separated the $8,000 savings transfer from operating revenue. Beside the $46,700 month, he noted that the deposits came from landings that would normally have been spread across part of the previous month as well.

The revised page still had 12 columns. Its bottom line did not change. What changed was the unit of explanation: instead of asking each calendar month to stand alone, Martin grouped the income around the opening, the active season and the maintenance period that followed.

That translation took longer than gathering the records. The lender's categories included recurring revenue, operating expenses and debt payments. Martin's own categories began with whether the boat left the dock and whether a buyer was accepting the catch. To complete the appeal, he had to place those facts inside boxes built for businesses whose sales happen throughout the year.

He also wrote a short account of the prior two seasons. It showed that revenue had arrived unevenly in both, although the latest year's delay made the pattern more pronounced. His average annual gross income for the three-year period was $117,100. The proposed loan payment would be about $1,160 a month for five years.

This was not a request for the lender to ignore risk. The engine could fail. Weather could cut another season short. Prices could move.

Martin wanted the review to distinguish those risks from the appearance that customers had stopped buying from him for four months.

A person reviewed the appeal. Martin was asked about the delayed opening and the transfer from savings, then about the cost of operating during months with little income. He explained that fuel spending dropped when the boat stayed in, while insurance and dock costs continued. The exchange was brief compared with the work behind the revised spreadsheet.

Six weeks after the original rejection, the lender approved the $58,000 loan. The term remained five years. The approval required Martin to keep part of his savings in the business, which left him with less cash available for an unrelated repair he had planned.

The decision did not establish that every seasonal business would pass the same review. It showed that the first assessment had treated a timing pattern as a condition of the business, and that the lender was willing to reconsider once a person could connect the bank deposits to the fishing record.

The cost of being read late

The engine replacement began seven weeks later than Martin had intended. While the appeal was pending, he limited longer trips because he did not trust the old engine. He estimated that he gave up two possible landings, though there was no way to know what those trips would have produced.

The new engine did not make his income regular. During its first full season, his largest monthly deposit was still more than five times his smallest. The payment, however, arrived every month.

Martin kept the revised spreadsheet on his computer and a paper copy with his tax records. He no longer saw it as an ordinary budget. It was a translation of work that had always been measured first in trips, openings and pounds, then converted into dollars after the boat returned.

Nothing in his experience amounts to financial advice. The lender controlled the appeal, and another institution could have treated the same records differently. Martin's approval also carried a cost: the reserve condition reduced the cushion he had built for the next bad stretch.

Months after the engine was installed, he opened the spreadsheet again to add the latest deposits. The columns still followed the calendar. His notes beneath them followed the water.

Questions people ask

Why would seasonal income look risky to automated loan analysis?

Automated analysis can compare deposits month by month and treat wide changes as a sign that revenue is unreliable. In Martin's case, the system did not connect quiet months to a delayed fishing opening or recognize that one large month contained income that usually arrived over a longer period.

Can a loan denial be reviewed by a person?

Martin's lender allowed an appeal and assigned a person to reconsider the records, but that was the process at this institution rather than a general promise. The human review did not discard the automated result. It examined the seasonal facts and the savings transfer that the first analysis had not placed correctly.

What records mattered in this appeal?

The appeal drew on Martin's fishing log, buyer settlement slips and bank records, but the revised spreadsheet connected them. It showed which deposits came from landings, which deposit was a transfer from savings, and how the delayed opening shifted income into a later month without changing the underlying work.

Did approval erase the cost of the delay?

No. Martin restricted longer trips while the application was under review, and the lender required him to retain cash in the business after approval. The engine was installed seven weeks later than planned. The printed spreadsheet remained folded with the engine estimate in his tax file.